SQL Developer · Bengaluru (Bangalore) · 4.5 - 8 years · ₹13L - ₹20L / yr · Posted 19 Oct 2023
SQL Developer
Amazon Web Services (AWS)- Structured Query Language (SQL), e.g. SQL/PSM, Transact-SQL queries, writes SQL scripts in SQL Server 2000/2005/ 2012/ 2016, etc.
- 1+ years in Cloud Database services like AWS Dynamo DB / RDS
- Excellent Troubleshooting skills of existing functional implementation to derive leaner solutions and effective performance between applications software, systems software, and installed hardware.
- Database instance maintenance tasks such as DB Integrity Checks, Index Maintenance.
- High availability like clustering, log shipping, mirroring, replication.
- Backup and disaster recovery, Capacity planning and performance monitoring, Physical database structure, RDMS administration roles, instances, profiles, and security connectivity.
- Developing, implementing, maintaining, and following change control and testing processes for modifications to databases.
- Establishing backup and recovery or replication plans to minimize data loss and system downtime.
- Improving data quality through data analysis, monitoring, gap analyses, and working with the teams to provide solutions and resolve errors.
- Maintaining data integrity and security (manage roles and permissions of database users).
- Reviewing the security logs from the SQL Server Error Logs to determine if you had a breach or a violation in one of your policies.
- Ensures optimal database performance and availability.
· Creation & maintenance of Databases in AWS.
Shubham Vishwakarma
Full Stack Developer - Averlon
Similar jobs (2)
Position : SQL Database Developer
Experience : 10+ Years
Domain : Mutual Fund / Capital Markets
Location : Noida
Work Mode : Hybrid
Role Overview :
We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.
Mandatory Skills :
- SQL Server & T-SQL
- Stored Procedures, Functions, Triggers, Views & SQL Jobs
- Complex SQL Queries & Data Manipulation
- Query Performance Tuning & Optimization
- Indexing, Execution Plans & Partitioning
- Data Migration, Porting, Transformation & Validation
- Database Troubleshooting
- SQL Server Performance Monitoring
- Version Control / Git
- Database Security & Data Integrity
Domain Knowledge :
- Mutual Fund / Capital Markets experience preferred.
- Understanding of financial transactions, reporting, reconciliation, and business processes.
Key Responsibilities :
- Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
- Perform query tuning, indexing, execution plan analysis, and performance optimization.
- Handle data migration, transformation, porting, validation, and reconciliation.
- Troubleshoot database and production/UAT issues.
- Ensure data accuracy, integrity, consistency, and security.
- Work with developers, BAs, QA teams, and business stakeholders.
- Independently own database development and optimization activities.
- Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.
PostgreSQLQualifications
● 3-8 years experience in Cloud Database Administration
● Proficient in PostgreSQL database management, including installation, configuration, and performance tuning.
● Experience with Amazon RDS or Cloud SQL and managing databases in cloud environments.
● Proficient in PostgreSQL/MySQL database management, including installation, configuration, and performance tuning.
● Proven experience as a Database Administrator with a focus on
PostgreSQL/MySQL.
● In-depth knowledge of database design, implementation, and management for both PostgreSQL/MySQL environments.
● Familiarity with database security, backup procedures, and performance tuning for both systems.
● Strong analytical and problem-solving skills.
● Excellent communication and collaboration abilities.
● Relevant certifications (e.g., PostgreSQL Certified Professional, MySQLDatabase Administrator) are a plus.
Skills:
● Expertise in PostgreSQL/MySQL database management systems.
● SQL programming and query optimization for both databases.
● Data modeling and database design for PostgreSQL/MySQL.
● Backup and recovery procedures for both environments.
● Performance tuning and optimization for PostgreSQL/MySQL.
● Security protocols and measures for PostgreSQL/MySQL.
● Capacity planning and scalability for both systems.
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon