Job title : Senior SQL DBA

Job Number : 89405
Division : Information Technology

Job Description:

The successful candidate will support the Network Enterprise Center (NEC) by providing day-to-day support and monitoring of the NEC's hosted database systems in Oracle, Microsoft SQL server and MySQL environments.

Task and Responsibilities:
• Provide operational support of computer hardware, system software, applications software, and system and user data files as configured within the associated database system.
• Provide advanced knowledge and understanding of applicable technical concepts and practices
• Supports development and engineering of database and data systems operating procedures and technical documentation
• Provide database and associated database systems administration support
• Provide maintenance for the integrity of all user/system data files, data verification following system restoration/recovery procedures, and data format conversion procedures during the import/export of data
• Lead and manage SAN maintenance, upgrading, patching, testing, debugging, and documentation of SAN configuration modifications
• Manage and implement database configuration, security, failover, and optimization of databases in high availability environment
• Implement and configure packaged real-time monitoring and alerting solutions
• Support ACAS server scanning and vulnerability review
• Provide PowerShell scripting and documentation
• Provide automation of tools, implementations, scripting and database reporting metrics and reports
• Design, plan and implement database changes to improve performance and security;
• Plan, coordinate, and implement database, data systems, data architecture, security, and integrity
• Measure database performance and troubleshoot complex database and HADR issues
• Configure and maintain schemas, table spaces, tables, indexes, buffer pools and logs