*Database Administrator - US Citizen Only.- **Direct Client * *Immediate Interview and Start ASAP!!!*
*Please send resume to **[email protected] <[email protected]>* Job Title: Database Administrator Location: Monterey, CA Duration: 12 Months Direct Client Position Client: US Navy Note: Need US Citizen only. 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 Tasks: The contractor shall perform the following tasks: 3.1 Design, enhance and maintain databases. The contractor shall monitor and improve database performance and capacity of existing enterprise database systems (Microsoft SQL Server, Oracle, and MySQL). The contractor shall monitor database performance and plan for future expansion of database systems, as well as manage and maintain all production and non-production databases. 3.2 Ensure that database systems are safeguarded and implement necessary security measures to ensure data integrity. The contractor will be responsible for controlling privileges and permissions to databases and for standards and design of physical data storage, maintenance, and access and security administration. 3.3 Create or modify database objects and/or write SQL code in support of application developers as specified in the NPS JIRA issue tracking system. 3.4 Perform data integration by creating or modifying Extract-Transform-Load (ETLs) of data using tools such as Microsoft SQL Server Integration Services (SSIS) and/or Pentaho Kettle. 3.5 Perform fiscal year changeover activities in the financial management system database (i.e., the Kuali Financial System database). The primary activities for fiscal year changeover are to be done during the month of October of each fiscal year. These activities primarily consist of taking data provided by the Kuali Financial System (KFS) functional team and performing data integration tasks. 3.6 Assist with upgrading KFS database for one new version release. Specifically, the contractor shall migrate the current KFS database to the new version, to include customizations NPS has made to the database. 3.7 Perform database server migrations in order to replace outdated or underperforming database servers. 3.8 Create a monthly report that provides update on status, work completed, work in progress, short-term goals, and other relevant project information. Minimum Technical Requirements: • The contractor shall have at least 6 months of experience in all areas associated with this contract, including database administration of Oracle, Microsoft SQL Server, and MySQL, SQL programming, and technical documentation. • At least 6 months of experience with Subversion SVN • At least 6 months of experience with Microsoft SQL Server Integration Services (SSIS) • At least 6 months of experience with Pentaho Kettle • At least 6 months of experience with the Nagios monitoring system • Moderate understanding and experience with T-SQL query development • CompTIA Security+ certification required OR the contractor will provide Security+ training and testing to ensure that the candidate receives Security+ certification within 4 months of the start of the contract. • Educational Requirements: Bachelor's Degree from an accredited college or university in computer science, mathematics, or engineering or a mathematics-intensive discipline, or an applicable training certificate from an accredited institution. *Please send resume to [email protected] <[email protected]> * *Thanks,Sam CNC Consulting, [email protected] <[email protected]>* -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
