ENT Database Administrator

Hi All, Greetings from Shivsys Softwares We are hiring for ENT Database Administrator Job Role: ENT Database Administrator Experience: 8+ Years Location: Remote 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. Email your updated CV at karan.prajapati@shivsys.com Show more Show less