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
Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
The PowerPoint Design Specialist refines presentations, creates visuals, collaborates on design standards, and improves brand engagement through effective storytelling in presentations.
Top Skills:
Adobe Creative SuiteAdobe XdCanvaFigmaIllustratorIndesignPhotoshopPowerPoint
Cloud • Fintech • Food • Information Technology • Software • Hospitality
The Sr. Lending Operations QA Analyst will ensure the accuracy and compliance of lending processes, optimize operations, and enhance quality assurance practices while collaborating with cross-functional teams.
Top Skills:
ExcelGoogle SuiteSnowflakeSQL
Artificial Intelligence • Consumer Web • Edtech • Enterprise Web • HR Tech • Social Impact • Generative AI
Lead the Globalisation engineering team, manage engineers, collaborate on scalable solutions, mentor team members, and drive product vision and technical direction.
Top Skills:
AWSDjangoDockerDynamoDBGraphQLGrpcHibernateJavaKotlinKubernetesMySQLPythonRestSpring Boot
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.
