The Senior Database Developer/Admin will oversee administration, management, and security of database servers, focusing on performance tuning, backup/recovery, and security. They will also collaborate with developers on database design and optimizations, troubleshoot issues, and work with cloud platforms like GCP and AWS. Strong experience with MS SQL, MySQL, and Postgres is essential, along with familiarity with tools such as Jira and Confluence.
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.
- 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.
Similar Jobs
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
As a Software Engineer at Atlassian, you will develop backend applications, build scalable RESTful micro-services, review code for best practices, mentor teammates, and participate in Agile development processes. You'll collaborate in a distributed team environment and ensure the performance of backend services.
Top Skills:
AWSAzureCassandraDynamoDBGaeGoJavaKotlinOraclePostgresPythonScala
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
As a Senior Machine Learning Systems Engineer at Atlassian, you will build and scale AI and ML infrastructure, enabling software engineers and data scientists to develop, deploy, and operate machine learning models. You will mentor junior members, drive technical projects, and collaborate with cross-functional teams to enhance the user experience with AI capabilities.
Top Skills:
Java,Kotlin,Aws
AdTech • Cloud • Digital Media • Enterprise Web • Software
The Staff Backend Engineer will design and develop impactful features, drive architectural decisions, and mentor team members. Responsibilities include solving complex problems, collaborating with stakeholders, and ensuring successful feature launches within a cross-functional Agile team.
Top Skills:
C#GCPGoJavaKotlinNoSQLRustSQL
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
