Job
Description
Job Description :
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.
Show more
Show less
