- Senior
- Office in Chennai
CES has 26+ years of experience in delivering Software Product Development, Quality Engineering, and Digital Transformation Consulting Services to Global SMEs & Large Enterprises. CES has been delivering services to some of the leading Fortune 500 Companies including Automotive, AgTech, Bio Science, EdTech, FinTech, Manufacturing, Online Retailers, and Investment Banks. These are long-term relationships of more than 10 years and are nurtured by not only our commitment to timely delivery of quality services but also due to our investments and innovations in their technology roadmap. As an organization, we are in an exponential growth phase with a consistent focus on continuous improvement, process-oriented culture, and a true partnership mindset with our customers. We are looking for the right qualified and committed individuals to play an exceptional role as well as to support our accelerated growth.
You can learn more about us at: http://www.cesltd.com/
We are seeking a highly skilled and proactive Senior Database Administrator to join our team. This hybrid role blends traditional DBA responsibilities with modern data engineering tasks to support our Comparative data loads and ensure optimal performance of critical database systems. You’ll play a key role in scaling our data infrastructure, diagnosing performance bottlenecks, and contributing to architectural improvements.
Key Responsibilities:
- Data Architecture & Scalability o Redesign and improve JSON blob storage strategies that have reached scalability limits. o Evaluate and optimize complex data structures spanning five core applications.
- Performance Tuning & Optimization o Analyze and resolve performance issues across PostgreSQL, MSSQL, and Snowflake environments.
- Refactor inefficient queries and recommend index strategies or schema redesigns.
- Support and tune Amazon RDS PostgreSQL deployments for high availability and performance.
- Data Engineering Support and Contribute to the design and maintenance of ETL pipelines that support Comparative data loads.
- Collaborate with data engineering teams on pipeline orchestration, transformation, and delivery.
Database Administration:
- Ensure high availability, backups, and disaster recovery across database platforms.
- Monitor and manage database health, security, and compliance.
GIS/Spatial Data (Helpful)
- Leverage experience with postGIS and/or spatialite to enhance location based features where applicable.
Technical Environment:
- Databases: PostgreSQL (Amazon RDS), MSSQL, Snowflake.
- Data Engineering & Orchestration: Apache Spark, dbt, Airflow, SSIS.
- Cloud & Infrastructure: AWS (including Infrastructure as Code practices)
Preferred Qualifications:
- 6+ years of experience in database administration and performance tuning.
- Proficiency with JSON data modelling and optimization.
- Strong SQL expertise with proven ability to refactor complex queries.
- Hands-on experience with Amazon RDS, particularly PostgreSQL.
- Familiarity with Apache Spark for distributed data processing.
- Familiarity with dbt for data modeling and transformations.
- Familiarity with Apache Airflow.
- Familiarity with MonetDB.
- Exposure to AWS Infrastructure as Code (IaC) using tools like CloudFormation or Terraform.
- (Nice-to-have) Experience working with spatial data formats (postGIS/spatialite).
- Strong collaboration skills and ability to work in a cross-functional, agile environment
