Position: MS SQL DBA
Location: Houston, TX
Installation, Creation and Maintenance of PostgreSQL DBs.
Administration of PostgreSQL databases throughout the development and production lifecycles.
Handle Backup and Restore/Recovery of databases as required.
Setup DB replication for high availability.
Space Management and Security (User Access) Management.
Design and Develop data migration scripts to consume multiple data sources (Relational Databases, CSVs, LDAPs) and generate feeds into databases / Directories Ability to analyze multiple database schemas / structures, users and create consolidated tables, SPs, views etc.
Documentation of steps to perform a task to create Standard Operating Procedures.
Works closely with software developers performing database design, database architecture, SQL programming, consultation and technical guidance with SQL server and Oracle databases
Good to have:
Experience in Linux/Windows platforms and shell/batch scripting.
Migration of Databases from Oracle/SQL Server into PostgreSQL DBs.
Performs database performance monitoring and tuning, including advanced skills in the effective use of database tools.
5-6 years of work experience as a PostgreSQL DBA, providing 24/7 support to mission-critical applications and databases Proficiency in PostgreSQL backup & recovery, upgrade, patching, and performance tuning Advanced knowledge of SQL query execution, execution analysis & optimization, indexing strategies, partitioning etc.
Advanced knowledge of SQL schema modelling and evolution Proficiency in various RDBMS replication strategies Excellent troubleshooting, documentation, and communication skills Experience with other database management systems is a plus
(O) EXT 482
NY Office: 112 W 34th St, 18th Floor, New York, NY 10120
PA Office: Unit #204, 5001 Louise Drive, Mechanicsburg, PA 17055
MS SQL DBA, PostgreSQL,
Testingxperts, Inc. DBA Damcosoft