PostgreSQL DBA Specialist
at Deloitte
Mechanicsburg, Pennsylvania, USA -
Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
---|---|---|---|---|---|---|---|
Immediate | 05 Jul, 2024 | Not Specified | 05 Apr, 2024 | 6 year(s) or above | Performance Tuning,System Configuration,Computer Science,Stored Procedures,Optimization,Information Systems | No | No |
Required Visa Status:
Citizen | GC |
US Citizen | Student Visa |
H1B | CPT |
OPT | H4 Spouse of H1B |
GC Green Card |
Employment Type:
Full Time | Part Time |
Permanent | Independent - 1099 |
Contract – W2 | C2H Independent |
C2H W2 | Contract – Corp 2 Corp |
Contract to Hire – Corp 2 Corp |
Description:
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 …
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-AM
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
REQUIREMENT SUMMARY
Min:6.0Max:11.0 year(s)
Information Technology/IT
IT Software - DBA / Datawarehousing
Information Technology
Graduate
Computer science engineering management information systems or equivalent work experience
Proficient
1
Mechanicsburg, PA, USA