Job Description
Technologies: Postgres SQL and MS SQL (Azure SQL, SQL Server Managed Instance, SQL Server)
Methodology: Code first and database first deployments
Key Areas Of Responsibility
• Create and manage multiple databases and assist in capacity planning.
• Monitor, maintain database systems and troubleshoot problems that may arise.
• Maintain data integrity and security (manage roles and permissions of database users).
• Generate traces, execution plans, identify performance issues deadlocks/contention and resolve them.
• Develop strategies and implement solutions for managing back-ups, restoration, and replication. database recovery including disaster recovery planning.
• Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
• Proactive housekeeping/archiving and shrinking of databases.
• Create detailed documentation including diagrams of database infrastructure.
• Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
• Set up and maintain database infrastructure for the company’s BI needs.
• Good to have Experience in ETL (Extract-Transform-Load) development / data integration.
• Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
• Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.
• Ability to develop procedure documents and maintain detailed database related documents.
• Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies
Methodology: Code first and database first deployments
Key Areas Of Responsibility
• Create and manage multiple databases and assist in capacity planning.
• Monitor, maintain database systems and troubleshoot problems that may arise.
• Maintain data integrity and security (manage roles and permissions of database users).
• Generate traces, execution plans, identify performance issues deadlocks/contention and resolve them.
• Develop strategies and implement solutions for managing back-ups, restoration, and replication. database recovery including disaster recovery planning.
• Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
• Proactive housekeeping/archiving and shrinking of databases.
• Create detailed documentation including diagrams of database infrastructure.
• Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
• Set up and maintain database infrastructure for the company’s BI needs.
• Good to have Experience in ETL (Extract-Transform-Load) development / data integration.
• Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
• Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.
• Ability to develop procedure documents and maintain detailed database related documents.
• Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies
💡 Quick Summary
Seeking a career-building opportunity? The Senior Database Administrator position is now open for candidates interested in the Database Administrator sector. This role in Ahmedabad offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
