Company Description
IDIQ has been on Forbes Fastest Growing Companies for the last 3 years and is looking to double the size of our Chennai office to grow it into an engineering centre of excellence for the company. IDIQ has engineering and technology resources in Eastern Europe, Chennai, and the United States, and is excited to grow and expand our engineering capabilities in Chennai on the latest technologies in patterns such as microservices, micro frontends, and cloud engineering utilizing .net core, react native and web, etc.
If you are looking to join a growing company and work among talented peers, we encourage you to apply today!
Job Description
Employment Type : Full Time
Role : Senior Database Administrator
Experience : 10 to 12 Years
Work Location: Chennai (Hybrid)
Working hours: (From 5.00pm to 2am IST Shift)
- Minimum of 12 years of working experience in IT.
- Minimum of 10 years of experience in administering, managing, securing, and tuning database servers (MS SQL Server, MySQL, & Postgres)
- Minimum of 3 years of cloud platform experience in CloudSQL/GCP or RDS/AWS.
- Highly Preferred scripting experiences: Python and PowerShell.
- Install, configure, and maintain database instances across various environments.
- Monitor database performance, identify and resolve issues related to performance, capacity, and reliability.
- Implement and manage database backup and recovery procedures to ensure data integrity and availability.
- Implement and manage database security policies, including user access control, data encryption, and auditing.
- Identify and implement optimizations to improve database performance, such as index tuning and query optimization.
- Maintain documentation of database configurations, procedures, and troubleshooting steps.
- Apply patches and updates to SQL Server instances in a timely manner to address security vulnerabilities and ensure compliance.
- Good understanding of database design – physical and logical schemas, and database modeling.
- Collaborate with developers to design and optimize database schemas and provide guidance on SQL best practices.
- Experience in query optimization and writing complex SQL queries.
- Experience in troubleshooting and resolving database integrity issues, blocking, and deadlocking issues, as well as performance issues.
- Strong knowledge of indexes, index management, and configuration management.
- Experience in SSAS, SSIS, SSRS.
- GCP’s Data warehouse platform experience is a plus (BigQuery, DataFusion, DataStream, DataFlow, & Looker)
- Work on projects as needed in close coordination with Architects, Project Managers, Application Architects, and Development teams.
- Ensure team collaboration using Jira, Confluence, and other tools.
Qualifications
- Bachelor’s degree or equivalent experience in computer science.
Additional Information
Position Details:
This is an exempt position (40 hours+ /week) and is not eligible for overtime. You will participate in a Managed Objective Bonus program. Days of work are Monday through Friday.
