Job
Description
Job Title: Sr.Database Engineer Location: Ahmedabad, Gujarat Job Type: Full Time Experience: 3+ Years Department: Data Engineering About the Role: We’re looking for a skilled and motivated Database Administrator (DBA) to join our team and support both on-premises SQL Server databases and cloud-based environments in AWS (RDS, Redshift). You’ll be responsible for ensuring database performance, stability, and scalability This role is ideal for someone who thrives in both traditional database environments and cloud-native architectures, enjoys problem-solving, and takes ownership of incident response and continuous improvement. Responsibilities: Administer, configure, and maintain Microsoft SQL Server (on-premises) and AWS RDS/Redshift environments. Perform regular maintenance tasks such as backups, restores, patching, and capacity planning. Manage database security, user access, and roles across environments. Provision, configure, and manage AWS RDS (SQL Server, PostgreSQL) and Redshift instances. Implement backup strategies, monitoring, and disaster recovery solutions in the cloud. Automate routine database tasks and processes using AWS tools and scripting. Deploy and monitor AWS Glue and AWS Lambda. Troubleshoot ETL job failures, ensure data quality, and support timely delivery of data. Use tools like AWS CloudWatch, SolarWinds, and Redgate SQL Monitor for real-time performance tracking and alerting. Identify and resolve performance bottlenecks in SQL queries, indexes, and server configurations. Act as a point of contact for database-related incidents and outages. Perform root cause analysis, document findings, and work with engineering teams to implement long-term fixes. Maintain comprehensive and up-to-date documentation on database systems, configurations, and procedures. Collaborate with development and DevOps teams to support database and data platform needs. Contribute to automation and infrastructure improvements in cloud and hybrid environments. Maintain detailed documentation and knowledge base articles for internal teams. Qualifications: Experience as a database administrator, with a strong foundation in SQL Server administration, backup/restore strategies, and high availability solutions (e.g., Always On, clustering). Hands-on experience managing AWS RDS (SQL Server/PostgreSQL) and Amazon Redshift, including provisioning, scaling, backups, snapshots, and security configurations. Proficiency with monitoring tools like AWS CloudWatch, SolarWinds, and Redgate SQL Monitor, with the ability to configure alerts, identify trends, and proactively address performance bottlenecks. Expertise in performance tuning for: SQL Server: Execution plan analysis, indexing strategies, TempDB optimization, query tuning. RDS: Parameter group tuning, performance insights, instance sizing. Redshift: WLM configuration, vacuum/analyze, distribution/sort keys, and query optimization. Strong understanding of database security best practices, user access controls, encryption, and auditing. Experience managing incident response, including root cause analysis, mitigation planning, and follow-up documentation. Ability to create and maintain detailed runbooks, SOPs, and knowledge base articles for repeatable processes and troubleshooting procedures. Comfortable working in hybrid environments, with coordination across on-premises and cloud-based systems. Familiarity with automation and scripting using PowerShell, Python, or Bash to streamline database tasks and monitoring. Hands-on experience with CI/CD pipelines to support database changes and deployments using tools like AWS CodePipeline or GitLab CI. Experience integrating database deployments into DevOps pipelines, including version-controlled DDL/DML scripts, pre-deployment checks, and rollback strategies. Ability to perform manual deployments when required (e.g., via SSMS, pgAdmin, or SQL scripts) while adhering to change management processes. Ability to work independently, manage priorities, and take ownership of tasks in a distributed team environment. Strong communication and interpersonal skills, with the ability to explain technical concepts clearly to both technical and non-technical stakeholders. A proactive and detail-oriented mindset, with a focus on continuous improvement and system reliability. Why Join Us: Young Team, Thriving Culture Flat-hierarchical, friendly, engineering-oriented, and growth-focused culture. Well-balanced learning and growth opportunities Free health insurance. Office facilities with a game zone, in-office kitchen with affordable lunch service, and free snacks. Sponsorship for certifications/events and library service. Flexible work timing, leaves for life events, WFH, and hybrid options
