Senior Database Administrator

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.