Manage and support PostgreSQL and Progress 4GL databases across different environments, ensure data integrity, optimize performance, and assist in 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 (Ssms)
Webspeed
Bahwan CyberTek Chennai, Tamil Nadu, IND Office
148, Rajiv Gandhi Salai(OMR), Okkiyam Thoraipakkam, , Chennai, India, 600 097
Similar Jobs
Aerospace • Digital Media • Information Technology • Internet of Things • Mobile • Software
The Senior Manager, Software Engineering oversees software development, manages teams, evaluates performance, and ensures project execution while collaborating across functions to meet business needs.
Top Skills:
AgileAPIsHadoopJavaJavaScriptNode.jsNoSQLRdbmsReactSafe
Artificial Intelligence • Big Data • Logistics • Machine Learning • Software • Transportation
The Customer Success Manager will manage relationships with enterprise customers, drive product adoption, reduce churn, and ensure customer satisfaction through consultative support and communication.
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Responsible for leading and supporting digital lab solutions, managing solution team backlog, maintaining system documentation, and providing technical support for lab systems.
Top Skills:
LimsModaMS Office
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.
