Bachelor’s Degree preferred, with emphasis in Computer Science, Information Systems or a related field, or equivalent experience.
5-8 years senior engineering leadership in system engineering database administration and team supervision (operating systems, design, architecture, stored procedures, business intelligence and implementation).
Must demonstrate ability to develop detailed technical and functional requirements. Must have a proven track record of team leadership
Defines architecture, business and IT drivers and coordinates the analysis, design and long term build-out and management of enterprise databases. Leads the efforts of DTI’s database team with the goal of improving response, effectiveness, accuracy and security.
Experience with Microsoft SQL, Mongo & Oracle DBA software installation and configuration, upgrades, version testing and debugging, installation of patches, and direct technical vendor interactions. Working knowledge of UNIX and Linux supporting Oracle databases. Microsoft SQL & Oracle database design, administration, debugging, tuning and recovery are a required.
Knowledge and/or experience with MSSQLSVR versions 2012, 2014 and 2016; all versions of Mongo; and Oracle 12c. It is understood that DBAs are expected to learn and become knowledgeable of higher versions of the databases as they are released by the vendor(s)
Experience in testing, debugging, and supporting MSSQLSVR SQL Reporting Services, and MSSQLSVR SQL Integration Services.
Experience in Server Operating Systems Windows 2012 and higher, Oracle Linux 7 and higher, and most versions of HP/UX along with the inter-dependent functions of Microsoft SQL, Mongo and Oracle DBA.
Experience with MSSQLSVR High Availability and Failover Clusters, SQL Server Replication, and SQL Server Agents (Jobs).
Experience with Oracle performance and turning, Data Guard, Advanced security, AuditVault, DB Firewall, Unified Auditing, LOB Storage and Materialized views.
Experience with Enterprise Manager (Grid Control), SolarWinds, Dell Toad, MSSQLSVR Management Studio, Oracle SQLDeveloper and Database Encryption.
Experience must demonstrate ability to develop detailed technical and functional requirements. Must have a proven track record of team leadership
Demonstrated ability to analyze and decide among alternative solutions to current and anticipated IT needs. Strong analytical skills, with particular emphasis on identifying creative solutions to IT problems within applicable constraints.
Ability to work with customers and key partners and lead cross-functional teams.
General experience that provides a good basic knowledge of the principles of organization, management, budget and administration.
Solid understanding of system design and server fundamentals. Overall knowledge of Operating System functions, hardware requirements and security zones. In-depth knowledge of Information Security issues, best practices policies and standards.
Demonstrated self-starter, able to work effectively with minimal supervision, good judgment in when and how to engage other parties, especially senior management.
Excellent interpersonal, written and verbal communication skills.
III. Supervision Received
The candidate must be able to work independently in accordance with his/her performance plan with minimal supervision. In most cases, the SE Lead Analyst – DBA will operate under broad directives but will communicate regularly with the Application Delivery Manager - Enterprise DBA and Team Leader.
IV. Supervision Given
Candidate must be able to effectively supervise and assign duties to as many as 10 people whose classifications may include client-server technologists, system engineering analyst/DBAs and engineers/technicians, all levels of IT support, contractors, and temporary staff.
V. Complexity and Scope
The Systems Engineering Lead Analyst - DBA directs highly technical service and support functions, therefore critical judgment and analysis is a continuous requirement, with particular emphasis during crisis situations that threaten service. The ability to calmly assess the situation, identify options, and recommend or approve interventions is absolutely critical to the job.
The scope of the technical infrastructure directly managed by the Application Delivery Manager is well defined, but the overall environment is highly complex and inter-related to other infrastructures. This calls for frequent and effective collaboration with other DTI managers and technicians, outside vendors, and even customers on an as-needed basis.
The Systems Engineering Lead Analyst - DBA must provide leadership and direction to Information Technology professionals across the State. Technical consulting, leading user groups, disseminating best practices and encouraging agency staff input and support will drive unified enterprise architecture.
Candidate must be a highly motivated self-starter, comfortable working in a high energy, dynamic start-up environment.
Delivery for enabling excellence in Delaware State Government. Candidate must be available when on-call or when calls require escalation per schedule.
Ability to interact and establish effective interpersonal relationships with people at all levels.
Ability to describe technology solutions in clear, detailed terms.
Ability to represent the Application Delivery Manager and Application Delivery Team Leader on information technology and other matters.
Ability to work with technical and non-technical personnel.
As required, the SE Lead Analyst – DBA will interact with auditors and other authorized parties.
VIII. Information Management
Assist the Application Delivery Team Leadership with overall strategic, technical, and tactical leadership of system development and server design, with special attention on value-adding initiatives and enterprise technologies and processes.
IX. Work environment
This position will require after hours access and availability.