Database Administrator

Job Description

Job Title: ENT DBA Location: Remote Experience: 8+ Years 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: 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).