What are the responsibilities and job description for the Sr PostgreSQL DBA position at Futran Tech Solutions Pvt. Ltd.?
Sr Postgres DBA
Location : Las Vegas NV day1 onsite .
Job Responsibilities
The primary objective of the Database Administrator (Sr DBA) is to develop and maintain the corporate databases ensuring data integrity, security, retention, and recoverability of the data.
In this role, the PostgreSQL DBA will design, build, test, and deploy quality database solutions that are consistent with project objectives, technology architecture standards and departmental best practices.
The DBA will design and implement database strategies, administer enterprise-wide data architecture, implement complex data structures, and provide daily management of Postgres databases.
The DBA will create and administer all database objects from design to deployment utilizing subject matter expertise to design or re-use, configure, and implement database solutions / processes that maximize system availability, efficiency, effectiveness, integrity, recoverability, and supportability. Specific responsibilities include :
- All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery.
- Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
- Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production.
- 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-though, and participation in weekly operations reviews.
- Proactive database monitoring and issue resolution through custom built scripts as well as using PgAdmin / Enterprise manager tools
- Database optimization including performance tuning, query optimization and supportability.
- Actively participate and contribute to projects involving enterprise systems enhancements.
- Implementation and ongoing support of high availability architecture not limited to Active / Active and Active / Passive Clusters
- Work with development project teams to design and implement database solutions to meet business requirements.
- Regular proactive capacity planning and tending reviews of all databases. Producing weekly, monthly management reports.
- Develop and implement Database security polices and procedures, in line with corporate objectives
Job Requirements
Not Required, but Preferred :
