As a member of the enterprise Storage and Database Hosting team, the Subject Matter Expert is responsible for keeping Oracle RAC and SQL server databases up and running fast, troubleshooting database errors, performance tuning inefficient database code, creating Oracle and Microsoft SQL Server databases, managing database storage, migrating databases from Solaris servers to Linux servers, setup Oracle Wallet and manage certificates.
In addition to Oracle, the Subject Matter Expert is responsible for the following:
Setup, installation, and support for the Microsoft SQL Server database management system, along with SQL Server Failover Clustering.
Setup, installation, backups, and support for:
PostgreSQL database management system
Sybase database management system
MySQL database management system
Provide monitoring, performance, and tuning of the four database management systems. Primary focus for this position is on the PostgresSQL and Sybase database management systems.
Experience with the Linux and Windows operating systems is required to create database server installation scripts
BASH and Powershell scripting
Performance tuning on backup/recovery issues and archive systems management software.
Combined Education and Experience as follows: Doctorate + 8 years; Master +10 years; Bachelor + 12 years; Associate + 15 years; or H.S./GED + 20 years.
Experience managing large scale databases to include Oracle: Database Management, primarily Oracle 10g, 11g, and 12c. This includes troubleshooting, performance tuning, and familiarity with Oracle networking; along with Automatic Storage Management (ASM), and Real Application Clusters (RAC).
Understanding of Oracle installation and patching processes, along with service request handling and understanding of Oracle OEM, Grid Control, DbConsole, and 12C Cloud Control; and Oracle backup and recovery features, especially RMAN (Recovery Manager) for backups.
Familiarity and/or understanding of the following is a plus, as these are areas the team supports:
Storage arrays, backups, and NAS’s/SAN’s
Best practices in relation to creation of aggregates, volumes and iSCSI LUNs
Zoning hosts to storage via command line interface
NFS, CIFS, and iSCSI protocols
EMC, IBM, and Hitachi (Vion) storage arrays
Oracle databases, PL/SQL, and other scripting languages
Robotic ACS controlled library
Oracle, Quantum, or IBM tape libraries and tape drives
Isilon and NetApp clusters
Vfiler (virtual filer) operations
TS/SCI with Polygraph required
Experience in Linux and Solaris environment
Familiarization with ticketing systems (i.e. SM7, SM9, Remedy, etc.)
We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.
GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.