Database Engineer

Job Description:

PRIMARY FUNCTION:

As a member of the Infrastructure Engineering & Planning (IE&P) team, the Database Engineer primarily works to ensure the stability, integrity, security and efficient operation of enterprise database systems that support core organizational functions.Database engineers achieve this result by designing, implementing, administering, monitoring, maintaining, supporting and optimizing enterprise database systems and database-related components of critical business applications.The Database Engineer works closely with systems engineers on the IE&P team, and functions as a liaison with the business units, working to design and implement database and infrastructure projects related to those business units.

JOB DUTIES AND RESPONSIBILITIES:

• Design, implement, monitor and maintain routine backups of all database systems as well as disaster recovery capabilities for those database systems; ensure that all system backups are properly completed; promptly resolve any issues with system backups or backup job failures.
• Administer database systems in all environments (production, training, test, development, and disaster recovery), ensuring maximum availability and performance.
• Design and build systems to report database availability, performance, and health; design and build systems to report service delivery and key performance aspects of critical applications.
• Build database tools and scripts that automate routine tasks.
• Create databases from the ground up by determining business requirements, creating logical models, building physical models and planning system architecture.
• Coordinate with software developers and systems engineers to ensure optimal application designs; conduct performance modeling, schema design reviews and query design reviews.
• Research innovative database solutions to improve business unit productivity and data security.
• Coordinate with systems engineers to design, acquire, install, maintain and support new hardware, systems and applications and to troubleshoot and resolve problems with critical applications and database systems.Understand database architectures and system interrelationships, and lead efforts to troubleshoot database systems.
• Develop and maintain system documentation including system diagrams, system overviews, system inventories, installation & configuration guides, operating procedures, maintenance & troubleshooting guides and disaster recovery plans.
• Promote and adhere to information security policies; ensure that all computing systems and usage of those systems comply with approved policies & industry best practices.
• Install and maintain hardware, firmware, hot fixes, patches and system updates as appropriate.
• Design, configure, and administer systems monitoring applications; update monitoring systems in conjunction with infrastructure and application design changes; take appropriate actions to prevent system outages; resolve incidents or alerts in a timely fashion.
• Assist with the maintenance and provisioning of all company-owned data centers and IE&P equipment in those data centers.
• Lead projects or tasks focused on implementing, critical business applications, upgrading existing systems or applications, or resolving issues.Assist other team members with their projects or tasks.
• Adhere to licensing requirements; ensure that all database systems are properly licensed.
• Assist the End User Services (EUS) team and/or other IE&P team members with advanced application and desktop support as needed.Collaborate with business units and external vendors to resolve issues.
• Participate in a periodic 24 x 7 on-call support rotation.
• Comply with all published enterprise level policies and procedures including, but not limited to, Risk Management policies.
• Complete all required, ongoing enterprise level training including, but not limited to BSA, OFAC, and Information Security.
• Report all Risk Management Policy violations in accordance with policy.
• Perform other duties as required or assigned by the supervisor/manager.

JOB QUALIFICATIONS:

Knowledge:

• In-depth understanding of database engineering technologies, including the design and implementation of database systems, and performance reporting, analysis and tuning (required).
• In-depth understanding of query languages and database task automation techniques (required).
• In-depth understanding of high availability system design and disaster recovery (required).
• Engineering/design skills for Microsoft server and workstation technologies including Windows operating systems, SQL Server, Internet Information Services (IIS), file/printer sharing, NTFS file/folder permissions and server security (required).
• Engineering/design skills for automation or interface scripts using industry-standard scripting languages such as Windows Management Instrumentation (WMI), VBScript, PowerShell and Perl (preferred).
• Working knowledge of Microsoft server and workstation technologies including Active Directory, Domain Name System (DNS) and Windows Software Update Services (WSUS).
• Working knowledge of networking and storage systems, (including storage area networks (SANs) and network-attached storage (NAS) systems) and Fibre Channel, all with a focus on NetApp technologies.
• Working knowledge of hardware virtualization systems, with a focus on VMware technologies such as VMware ESXi Server.
• Working knowledge of hardware systems and blade technologies, with a focus on HP ProLiant server/blade systems.
• Working knowledge of TCP/IP and networking.

Skills:

• Possess positive interpersonal skills that will promote effective interdepartmental communication.
• Understanding of basic project management techniques, including the ability to develop and follow project schedules.

Abilities:

• Ability to perform well both unsupervised and as a member of a technical team.
• Proven record of successful project completion.
• High levels of creativity, self-motivation, and interest in current technology and business applications of that technology.

Minimum Education and Experience:

• Bachelor's degree in Computer Science, Computer Engineering or Information Technology, or an appropriate combination of education and significant relevant work experience.
• Microsoft Certified IT Professional (MCITP) (SQL Server technologies), Microsoft Certified Technology Specialist (MCTS) (SQL Server technologies), Microsoft Certified Database Administrator (MCDBA), or equivalent top-level database certification (preferred).
• Demonstrated proficiency in Microsoft SQL Server database administration (required).
• Experience working in enterprise-level computing environments, designing, implementing, maintaining and updating database systems, with up-to-date Microsoft SQL Server 2008 R2 or SQL Server 2012 database engineering and administration skills, performance analysis, tuning, and data retention and recovery techniques (required).

PHYSICAL REQUIREMENTS:

• This job requires the ability to sit for long periods of time.
• This job requires occasionally lifting up to 50 pounds and/or frequently lifting up to 30 pounds.