What You'll Be Doing
Would you like to join a team of forward-thinking professionals who are committed to putting people first, providing reliable and high-quality interactions and services, and always being dependable? At
Wake County Information Technology, we provide information technology services to the organization and strive to provide customer services that are easy, enjoyable and exceed expectations.
As the
Senior Database Engineer, you will administer, maintain, develop and implement policies and procedures to ensure the security and integrity of the
County’s Oracle and SQL Server databases. In this role you will collaborate with cross-functional teams to design, build, upgrade, modify and operationally administer new and existing databases in support of critical enterprise applications.
Essential Functions
- Lead the design, construction and management of complex databases. Administers the Microsoft SQL Server and/or Oracle database production and test environments on a day-to-day basis including backups, security, patches, replication and change management
- Develops and implements policies and procedures for ensuring the security and integrity of Wake County databases
- Implements data models and database designs, data access and table maintenance codes Designs and builds relational databases using Microsoft SQL Server and/or Oracle. Develops and lead strategies for data acquisitions, archive recovery and implementation of a database. Implements change control procedures
- Coordinates production scheduling with other technical staff. Serves as technical lead and consults with business owners and developers during projects and implementation
- Manages licenses and upgrades in the Microsoft SQL Server and/or Oracle environments
- Performs analysis, planning and facilitation of data migrations and scripting to manipulate data
- Resolves database performance issues, database capacity issues, replication and other distributed data issues
- Performs platform backups, upgrades and installs. Provides continuous platform monitoring, maintenance and fine tuning of servers, tools and databases to ensure the highest level of data availability, integrity and security
- Administers security, patches, configures replications and monitors scheduled jobs and performance
- Participates in project meetings and dialogs regarding database related project components
- Provides realistic estimates of specific project related tasks to the project manager
- Provides prompt and clear communication of project task status and any related issues in project meetings and through email and phone dialogs
- Mentoring of junior staff and contract DBA's
- Stays current on SQL and/or Oracle platform environment technology upgrades and changes to ensure a stable and scalable SQL and/or Oracle platform for Wake County
Additional Requirements: Position is subject to 24-hour on call requirements.
NOTE: For positions with a remote work option, all Wake County Government remote workers must reside in one of the following states or districts: North Carolina, Florida, Georgia, South Carolina, Tennessee, Texas or Virginia.
About
About Our Team
Wake County Information Technology is in the heart of Raleigh’s booming downtown, a part of the Research Triangle area. If you’re a tech-guru, this is the place to be. Our team of smart, dedicated people is respected within our organization and recognized as leaders in the use of technology by the prestigious Center for Digital Government, regularly ranking in the top ten among counties with a population for 1 million or more. Our team members are our most valued asset and treated as such with competitive salaries and top-notch benefits. We believe a good work/life balance helps people make better decisions, be more creative and enjoy coming to work. If you thrive in a highly collaborative, fast-paced, supportive environment, then you owe it to yourself to check us out.
Required
The Basics (Required Education and Experience)
- Bachelor's degree in Computer Science, Information Systems, Computer Engineering or related field
- Four years of experience in network or database design and administration
- Equivalent education and experience are accepted
- Please include ALL prior work experience on your application and resume.
Beyond the Basics (Preferred Education and Experience)
- 3 years experience installing and supporting MS SQL Server 2008 - 2019 or Oracle versions 11.2 through Oracle 19C
- 3 years extensive experience using SQL Server Integration Services (SSIS) or writing and reviewing Oracle PL/SQL
- 3 years advanced SQL Coding skills for both ad hoc usage and creation of stored procedures and functions
- 3 years experience using SQL Server Reporting Services (SSRS) or SQL Plus
- 2 years experience using MS PowerShell or BASH shell languages
- 2 years experience supporting both hosted and on-premises applications
- Experience writing programs and scripts using the C# programming language/VB .Net or BASH
How Will We Know You're 'The One'?
- Knowledge of the principles and practices of customer service to develop and maintain a high level of customer satisfaction with the services delivered by the department
- Ability to work cooperatively in a team environment
- Excellent verbal and written communication skills
- MS SQL server mirroring and Availability Groups or VMware clustering technology
- Understanding and knowledge of MS software or Oracle Licensing
- Working knowledge of Cohesity backup and recovery for MS SQL or Oracle
- Working knowledge of MS SharePoint Working knowledge of Storage Array Network (SAN) technology
About This Position
Location: Waverly F. Akins Wake County Office Building Raleigh, NC 27602
Employment Type: Regular
Work Schedule: Mon - Fri, 9:00am - 5:45pm, On-call as scheduled
Hiring Range: 104,889 – 122,370
Market Range: 87,408.00 - 157,332.00
Please include
ALL prior work experience on your application and resume.
Posting Closing Date: 7:00 pm on 9/7/2024
What Makes Wake Great Equal Opportunity Statement Background Check Statement Emergency Service Worker Statement
What Makes Wake Great
Home to the State Capital, Wake County is one of the fastest growing areas in the nation and the most populous county in the state, with more than 1.1 million residents. The County has received national and international rankings and accolades from publications such as Money, Fortune, and Time magazines as being one of the best places to live, work and play. The central location of the County allows for a short drive to the spectacular mountains or coast. Wake County Government is governed by a seven-member Board of Commissioners, who are elected at-large to serve two-year terms. Wake County Government has a general operating budget of $1.874 billion, employs over 4400 employees, experiences minimal turnover, and is an award-winning leader in wellness and technology initiatives; such as offering employees and covered spouses free access to the Employee Health Center. Wake County Government offers a wide range of training and development opportunities, a stable career in public service with a balance of work and family life, flexible work schedules and a competitive salary and benefits package.
Equal Opportunity Statement
Wake County provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.
Background Check Statement
Position may require a background check that may include: criminal, credit, motor vehicle, education, and sexual offender registry or others based on job requirements. Unless required by state law, a record of conviction will not automatically exclude you from consideration for employment. Wake County Government is an Equal Opportunity Employer.
Emergency Service Worker Statement
In the event of an emergency, as determined by the County Manager or designee, participation in preparedness and response operations should be expected. Employee may be required to fill a temporary assignment in a role different from standard duties, work hours and/or work location in preparation for, during and after the emergency. Employee may also be required to participate in relevant exercises and regular preparedness training.
