Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Db postgres automation engineer Dallas Tx ref

Experience level: Mid-senior Experience required: 8 Years Education level: Bachelor’s degree Job function: Information Technology Industry: Financial Services Compensation: $91,000 - $100,000 Total position: 1 Relocation assistance: No
JOB DESCRIPTION:

The Principal Database Engineer is an Aurora PostgreSQL Database and Automation engineer and is responsible for supporting all aspects of the design, build, and support of the cloud database environments through automation. The Principal Engineer is responsible for ensuring that the environments are performing optimally and align to best practices for security and resiliency.
The Data Engineering team designs and builds secure, resilient, recoverable, and reusable frameworks to support the entire database life cycle. The team focuses on continuous service improvements to increase the quality of service and speed of delivery.
The Principal Database Engineer is an Aurora PostgreSQL Database and Automation engineer and is responsible for supporting all aspects of the design, build, and support of the cloud database environments through automation. The Principal Engineer is responsible for ensuring that the environments are performing optimally and align to best practices for security and resiliency.
RESPONSIBILITIES:

Support and manage the Aurora PostgreSQL database environments
Automate the build and support tasks across database technologies (i.e. Oracle, MS SQL, and PostgreSQL)
Adhere to best practices on Incident, Problem and Change management
Lead projects independently with minimal guidance
Responsible for managing and supporting Aurora PostgreSQL database platforms working closely with AWS, application support teams, and infrastructure teams
Install, configure, upgrade, and maintain database instances on AWS
Recommend and implement database security policies
Recommend and implement database backup, recovery, and redundancy strategies
Implement automated procedures to proactively handle issues and alerts
Perform database performance analysis, capacity planning, system sizing and ongoing maintenance
Aligns risk and control processes into day-to-day responsibilities to monitor and mitigate risk and escalates appropriately
Demonstrates reliability by taking necessary actions to continuously meet required deadlines and goals.
Applies global perspective when working within a team by being aware of working styles and ensuring all relevant parties are involved in key team tasks and decisions
Articulates information clearly and presents information effectively and confidently
Thinks boldly and out of the box, generates new ideas and processes, and confidently pursues challenges as new avenues of opportunity.
QUALIFICATIONS:

Minimum of 8 years of related experience, with a minimum of 5 years of related PostgreSQL experience
Bachelor's degree preferred or equivalent experience
Strong knowledge on AWS cloud technologies; AWS certification would be a plus
5+ year experience managing large scale Aurora database environments
Strong performance Tuning and Optimization skills including re-writing SQLs for optimal performance.
Extensive experience with Automation using Terraform, Ansible, Chef
Strong knowledge of operating systems (Unix / Linux / Windows)
Hands on experience with Shell and Python scripting to automate tasks enabling self-healing capabilities
Strong experience with partitioning and handling large databases
Understands interlaying technologies like OS, Networking, Applications, and its impact to databases
Manage tasks and projects independently with minimum guidance and directions
Ability to independently research, design, document and implement new database related services
Solid experience in backup and recovery processes
Ability to work in a complex environment to determine business and customer needs and provide the best solution needed
ABOUT:

safeguards the financial markets and helps them run efficiently, in times of prosperity and crisis. We are uniquely positioned at the center of global trading activity, processing over 100 million financial transactions every day, pioneering industry-wide, post-trade solutions and maintaining multiple data and operating centers worldwide. From where we stand, we can anticipate the industry’s needs and we’re working to continually improve the world’s most resilient, secure, and efficient market infrastructure. Our employees are driven to deliver innovative technologies that improve efficiency, lower cost, and bring stability and certainty to the post-trade lifecycle. DTCC proudly supports Flexible Work Arrangements favoring openness and gives people freedom to do their jobs well, by encouraging diverse opinions and emphasizing teamwork. When you join our team, you’ll have an opportunity to make meaningful contributions at a company that is recognized as a thought leader in both the financial services and technology industries. A career is more than a good way to earn a living. It’s the chance to make a difference at a company that’s truly one of a kind.