PostgreSQL DBA Specialist

at  Deloitte

Mechanicsburg, Pennsylvania, USA -

Start DateExpiry DateSalaryPosted OnExperienceSkillsTelecommuteSponsor Visa
Immediate05 Jul, 2024Not Specified05 Apr, 20246 year(s) or abovePerformance Tuning,System Configuration,Computer Science,Stored Procedures,Optimization,Information SystemsNoNo
Add to Wishlist Apply All Jobs
Required Visa Status:
CitizenGC
US CitizenStudent Visa
H1BCPT
OPTH4 Spouse of H1B
GC Green Card
Employment Type:
Full TimePart Time
PermanentIndependent - 1099
Contract – W2C2H Independent
C2H W2Contract – 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