The role involves database administration, supporting production environments, performance tuning, code deployment, and release management.
Job Description:
Responsibilities:Database Administration:
- Manage and support Production, QA, and Development environments for PostgreSQL and Progress 4GL databases.
- Monitor and manage database backups and ensure proper data growth management.
- Refresh Dev, Test, and Preprod environments by syncing them with the Live environment.
- Tune database performance by analyzing and optimizing query execution, index usage, and general database configurations.
- Perform Database Dump and Load operations, including experience with Progress database management.
- Ensure data integrity and consistency across different environments (Dev, Test, Preprod, and Production).
- Troubleshoot database-related issues, especially around code deployments, compilation, and their interaction with the database.
- Collaborate closely with the Development Team, providing support for database-related queries, optimizations, and issues.
- Use PROMON and other tools to regularly perform database health checks.
- Proactively monitor database performance and make adjustments to ensure optimum functionality.
- Experience in tuning performance issues and implementing changes when necessary.
- Knowledge of Appserver and Webspeed to optimize the performance of Progress-based applications.
- Manage SQL Server instances using SQL Server Management Studio (SSMS).
- Perform regular backup and restore operations for SQL Server databases.
- Prepare runbooks for production releases, outlining all steps and procedures for application deployment and database changes.
- Assist in Release Management by coordinating deployment schedules and ensuring that deployment goes smoothly.
- Handle deployment issues, ensuring the release process is seamless across all environments.
- Experience managing both PostgreSQL and Progress 4GL databases.
- Expertise in database backups, restores, and data refreshes across environments.
- In-depth experience with database performance tuning (e.g., query optimization, indexing).
- Familiarity with Progress 4GL queries, Appserver, and Webspeed.
- SQL Server management skills (backup, restore, etc.) are a plus.
- Experience with release management and writing/maintaining runbooks.
Top Skills
Appserver
Postgres
Progress 4Gl
Promon
Sql Server Management Studio
Webspeed
Bahwan CyberTek Chennai, Tamil Nadu, IND Office
148, Rajiv Gandhi Salai(OMR), Okkiyam Thoraipakkam, , Chennai, India, 600 097
Similar Jobs
Cloud • Fintech • Food • Information Technology • Software • Hospitality
The Senior Backend Software Engineer will design and maintain backend systems, optimize performance, lead projects, mentor junior engineers, and align technical decisions with business outcomes.
Top Skills:
AWSDockerJavaKafkaKotlinKubernetesPostgresSpring Boot
eCommerce • Fintech • Real Estate • Software • PropTech
The Automation Engineer will enhance operational efficiency by developing automated solutions using scripting languages, collaborating with engineering teams, and continuously improving tools and processes.
Top Skills:
JavaScriptPythonTypescriptXMLZapier
Cloud • Fintech • Food • Information Technology • Software • Hospitality
The Principal Software Engineer will design and implement advanced backend solutions, mentor engineers, ensure high-quality service delivery, and optimize performance for restaurant financial services.
Top Skills:
SparkAWSAzureDynamoDBGCPJavaKotlinPostgresRabbitMQReactSQL Server
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
