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
