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.
