Database Administration Services
1.0 Background/Introduction:
The Naval Postgraduate School (NPS) located in Monterey, California supports the U.S. Navy, other military branches, and foreign military services with postgraduate education for personnel. Additionally, NPS provides significant research capabilities to the Department of Defense (DoD). The Information Technology and Communication Services (ITACS) Department at NPS provides information technology (IT) support to the entire school.
2.0 Scope:
The Information Technology and Communication Services (ITACS) division provides support and service for all IT and telecommunications issues for the NPS community. Over years, ITACS has deployed several applications that implement enterprise database platforms (Microsoft SQL Server, Oracle, and MySQL).
In order to effectively support various enterprise applications, a Database Administrator is needed to monitor database performance for optimal database operations, support existing databases, plan for future growth, and manage database security. The objective of this contract is to provide a database administrator to support enterprise database management systems. As of the 4th quarter of FY 2016, the DBA supports:
2.1 MS SQL Server: 25 unique instances running on 19 database servers (some physical and some virtual)
2.2 Oracle: 5 database servers
2.3 MySQL: 2 database servers
2.4 Approximately 400 databases: ~ MS SQL Server databases, ~21 Oracle database, ~20 MySQL databases
2.5 ETL (Extract-Transform-Load): Approximately 70 ETLs
2.6 Scheduled Database Jobs: approximately 150
Matthew White 831-392-7335
