Postgresql Database Administrator

Are you an experienced, passionate pioneer in technology? A solutions builder who wants to work in a collaborative environment. As an experienced PostgreSQL Database Administrator, you will have the ability to share new ideas and collaborate on projects as a consultant without the extensive demands of travel. Consider an opportunity with our US Delivery Center - we are breaking the mold of a typical Delivery Center.
Our US Delivery Centers have been growing since 2014 with significant, continued growth on the horizon. Interested? Read more about our opportunity below ...
Work you will do/Responsibilities

• Lead PostgreSQL database management activities including improving database quality and scripts while developing and deploying DB scripts for data quality, stability, and security systems to support maintenance activities that meet or exceed SLAs
• Maintain PostgreSQL Server Database performance, integrity, and security
• Develop innovative PostgreSQL solutions
• Support the project team with ad-hoc query generation and analysis
• Support the PM with project/task scoping by analyzing the client requirements, coming up with approach, tasks, and level of effort
• Complete physical/logical database schema and object design; Develop new tables, views, triggers and indexes to support a complex data model and ensure optimal database performance

The Team
Deloitte's Government & Public Services practice-our people, ideas, technology and outcomes-is designed for impact. Our team of over 15,000+ professionals bring fresh perspective to help you anticipate disruption, reimagine the possible, and fulfill your mission promise.
Core Technology Operations (CTO) offers differentiated operate services for our clients with solutions to help organizations scale and optimize critical business operations, drive speed to outcome, deliver business transformation, and build resilience in an uncertain future by utilizing our CTO Offerings. Differentiation and focused growth for large-scale infrastructure, data center, and operations projects by scaling operations services. Emphasis on automation and delivery excellence, we can create core transformational change for our clients and drive value.
Qualifications Required

• Bachelor's Degree preferably in Computer Science, Engineering, Management Information Systems, or equivalent work experience

• 6+ years of experience with native PostgreSQL Server tools
• 6+ years of experience designing and developing documentation on database designs (i.e., stored procedures, configuration files, tables, views, and functions)
• Experience troubleshooting performance and database issues
• Experience with Performance Tuning and Query Optimization

• Experience using AWS RDS
• Experience working with other AWS tools

• Ability to execute user/security management and document system configuration
• Ability to create and document standard operating procedures as pertains to DB maintenance
• Ability to create functions and stored procedures to provide custom functionality as per the requirements

• Ability to travel 10%, on average, based on the work you do and the clients and industries/sectors you serve. This may include overnight travel.
• Expected to co-locate in your designated office/USDC location up to 30% of the time
• Must live in a commutable distance to or be willing to relocate to one of the following Delivery locations: Atlanta, GA; Charlotte, NC; Dallas, TX; Gilbert, AZ; Houston, TX; Lake Mary, FL; Mechanicsburg, PA; Philadelphia, PA
• Must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future
• Must current possess an active Top Secret security clearance

Information for applicants with a need for accommodation: https://www2.deloitte.com/us/en/pages/careers/articles/join-deloitte-assistance-for-disabled-applicants.html
#LI-AM3