What you’ll be doing:
- Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
- Effectively coordinate and communicate with all the stakeholders (internal teams and stakeholders). Advise developers on the most efficient database designs. Set up and maintain database infrastructure.
- Learn relevant business processes and understand the data flow, criticality and dependencies.
- Troubleshoot SQL Server service outages as they occur, define SLA and ensure support when required.
- Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
- Enhancements and Improvements to Existing Database Systems Infrastructure.
- Determine the most effective way to increase performance including hardware recommendations, server configuration changes, performance tuning etc.
- Setup and test High-Availability as part Disaster Recovery Strategy for the Databases to ensure ability to meet the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
- Execute data migrations to/from various platforms/engines and database upgrades.
- Maintain data integrity and security (manage roles and permissions of database users).
- Manage production, staging, and development database environments.
- Proactive housekeeping of databases.
- Configure SQL Server monitoring utilities to minimize false alarms.
- Create detailed documentation including diagrams of database infrastructure.
Key Responsibilities:
Database Administration:
- Manage databases: MS SQL Server, MySQL, PostgreSQL, MongoDB, Oracle.
- Administer AWS RDS for MySQL, PostgreSQL, SQL Server.
- Implement master-slave, active-active, and backup strategies.
- Optimize performance and conduct query analysis.
Cloud and Tools:
- Use AWS services: Redshift, S3, RDS.
- Implement SQL Server clustering and high availability (HA) technologies.
- Utilize SQL Server management tools like Redgate.
What we’re looking for:
- 5-6 years working experience in Advanced administration of database like MS SQL server, MySQL (incl. Amazon Aurora)
- Working knowledge in MySQL and In-Memory Databases (Redis, MongoDB,etc)
- Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
- Experienced in SQL Server Integration Services (SSIS)
- Experienced in ETL (Extract-Transform-Load) development / data integration.
- Experience in creating data hooks for analytics tools like – PowerBi, Tableau,Insights.
- Sound knowledge of RDBMS concepts, database design and SQL/T-SQL.
- Experience in SQL Server Clustering and HA technologies including mirroring,log shipping, failover cluster and various replication technologies would be an advantage.
- Have knowledge of SQL Server management tools like Redgate etc.
- Knowledge of various database platforms (SaaS, PaaS, IaaS, etc. )
- Good to have experience on Mulesoft.
- Postgres sql and sound knowledge of oracle
- Has an innovative approach to work, constantly looking to upgrade the system to more efficient and effective new technologies.