SQL DBA + Developer
Posted on September 2, 2025
Job Description
- Position 1: SQL DBA + Developer
- Experience: 8 Plus years
- Work Timings: 2 to 11PM
- Job Description:
- We are seeking a skilled and proactive Database Administrator (DBA) with strong SQL Development expertise to manage, optimize, and support our database systems. The ideal candidate will have hands-on experience with cloud-based and on-premises database platforms, with a strong emphasis on AWS RDS, PostgreSQL, Redshift, and SQL Server. A background in developing and optimizing complex SQL queries, stored procedures, and data workflows is essential.
- Key Responsibilities:
- Design, implement, and maintain high-performance, scalable, and secure database systems on AWS RDS, PostgreSQL, Redshift, and SQL Server.
- Develop, review, and optimize complex SQL queries, views, stored procedures, triggers, and functions.
- Monitor database performance, implement tuning improvements, and ensure high availability and disaster recovery strategies.
- Collaborate with development and DevOps teams to support application requirements, schema changes, and release cycles.
- Perform database migrations, upgrades, and patch management.
- Create and maintain documentation related to database architecture, procedures, and best practices.
- Implement and maintain data security measures and access controls.
- Support ETL processes and troubleshoot data pipeline issues as needed.
- Mandatory Skills & Experience:
- Strong hands-on experience with:
- AWS RDS
- PostgreSQL
- Amazon Redshift
- Microsoft SQL Server
- Proficiency in SQL development, including performance tuning and query optimization.
- Experience with backup strategies, replication, monitoring, and high-availability database configurations.
- Solid understanding of database design principles and best practices.
- Knowledge of SSIS, SSRS & SSAS development and its management.
- Knowledge of database partitioning, compression, online performance monitoring/tuning.
- Experience in database release management process and script review.
- Knowledge of Database mirroring, AAG and Disaster Recovery procedures.
- Knowledge in Database monitoring and different monitoring tools.
- Knowledge in data modeling, database optimization and relational database schemas
- Knowledge in writing complex SQL queries and debugging through someone else�s code.
- Experience in managing internal and external MS SQL database security.
- Knowledge in Database Policies, Certificates, Database Mail, Resource Management
- Knowledge in SQL Server internals (Memory usage, DMVs, Threads, wait stats, Query Store, SQL Profiler)
- Knowledge of Cluster Server management and failovers.
- Knowledge of data modeling (SSARS), Reporting Services (SSRS, Tableau, PowerBI, Athena).
- Good to have Skills:
- Exposure to MySQL and Oracle databases.
- Familiarity with Azure Database Services (e.g., Azure SQL, Azure Database for PostgreSQL).
- Knowledge of scripting languages (e.g., Python, Bash) for automation is a plus.
- Experience working in Agile/Scrum environments.
- Knowledge of Java, PowerShell, or Python is preferred.
Required Skills
strong hands-on experience with: aws rds postgresql amazon redshift microsoft sql server proficiency in sql development
including performance tuning and query optimization. experience with backup strategies
replication
monitoring
and high-availability database configurations.