Are you an experienced, passionate pioneer in technology? A solutions builder who wants to work in a collaborative environment. As an experienced PostgreSQL DBA Specialist, 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 TeamDeloitte'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.
Must live in a commutable distance (approximately 100-mile radius) to one of the following Delivery locations: Atlanta, GA; Charlotte, NC; Dallas, TX; Gilbert, AZ; Houston, TX; Lake Mary, FL; Mechanicsburg, PA; Philadelphia, PA with the ability to commute to assigned location for the day, without the need for overnight accommodations
Expectation to co-locate in your designated Delivery location up to 30% of the time based on business needs. This may include a maximum of 10% overnight client/project travel.
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 All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.