Posting number: 26-03956
Department: Department of Information Technology Services
Job classification: Senior IT Systems Administrator
Posting type: Open
Categories: IT and Computers, Database Administration
Summary[CHOOSE ONLY ONE OF THE FOLLOWING OR DELETE SECTION IF N/A:]Job Description
Utilize Data Classification tools to automatically scan, discover, and classify structured data based on sensitivity levels and potential impact. Utilize Data Encryption tools to encrypt structured data identified to contain sensitive data and decrypt the databases that are encrypted when the sensitive data has been removed to save encryption licenses. Help County with the Azure cloud migration of on premises database servers to reduce cost and increase efficiency. Support Oracle and SQL Server databases from 2016 and up throughout the county.
Essential Duties
Management Reporting: Help upper management with the number of servers/databases being monitored by extracting data, building data pipelines and reports.
Use Visio to make connection flow diagrams.
Use PowerShell scripting to get various information from all SQL servers using automated jobs.
Experience in managing and leading technical projects.
Proven ability to make responsible decisions.
Provide directions to peers and customers.
Oversee and monitor results.
Advanced SQL Server (2016 and higher) experience in enterprise-wide database administration, installation, upgrade and configuration, advanced troubleshooting, advanced tuning/optimization, and capacity planning.
Oracle 19c database and administration, and RMAN recovery experience.
Oracle Database Appliance experience.
- Present change requests for approvals in weekly CAB reviews
- Participate in Know Your Environment sessions
- Participate in vendor and interdepartmental meetings and discussions on key projects
- This job is a civilian position in either a public safety department or in Information Technology with close ties to public safety. Due to the sensitive nature of this position, a public safety background which may include motor vehicle & criminal histories, and fingerprinting.
- This job requires fingerprinting.
- This job may require on-call rotation and emergency after hours, weekends, and/or holidays.
The grade for this position is C451. Salary will be dependent on education and experience.
Effective 4/11/2023, this position is eligible for the Employee Referral Program.
Minimum Qualifications
- Bachelor’s Degree in a related field AND
- Five years of progressively responsible, professional level analyst and systems experience in a large-scale Information Technology environment;
- An equivalent combination of education and experience sufficient to successfully perform the essential duties of the job such as those listed above will also be considered.
- Valid Driver’s License from state of residency
For information related to position-specific essential duties, knowledge and skills, and physical requirements, please click here.
Note: The class specifications listed on this website are not the official class specifications for Gwinnett County and are subject to change.
For more information about this department, please click here. QualificationsAbout Gwinnett County
<span class="fr-mk" style="display: none;"> </span>
Welcome to Gwinnett County Government
Gwinnett County Government is an award-winning employer that believes in investing in its employees by providing corporate level benefits, a wellness program, professional development opportunities, career advancement, and more
Careers with impact
Gwinnett County sets the standard as a dynamic, vibrant community where all people can enjoy economic opportunities, safe neighborhoods, plentiful greenspace, and recreational facilities. We are committed to hiring those who share our dedication to making life better for our residents and business owners. The culture of superior service that our employees have created reflects that standard and helps staff, residents, and stakeholders remain vibrantly connected.
Exceptional benefits
Working for Gwinnett County comes with exceptional benefits, including health coverage, a robust wellness program (Spouses can participate, too!), onsite employee wellness center, longevity pay, tuition reimbursement, and more. The value of Gwinnett County benefits can be up to 49 percent of an individual’s total compensation.
World-class community
More than a million residents make up Gwinnett’s diverse community. The County is located just 45 minutes from Hartsfield-Jackson Atlanta International Airport and 30 minutes from downtown Atlanta. Georgia Highway 316 reduces travel time to the University of Georgia to 25 minutes.
Gwinnett County is an award-winning employer!
- Atlanta’s Healthiest Employer by Atlanta Business Chronicle
- Green Communities Platinum Certification for Gwinnett County from the Atlanta Regional Commission
- Top 100 Healthiest Workplaces in America by Springbuk and PR NewsWire and more!
Vision
Gwinnett is the preferred community where everyone thrives!
Mission
Gwinnett proudly supports our vibrantly connected community by delivering superior services.
Values
Integrity: We believe in being honest, building trust, and having strong moral principles.
Accountability: We believe in stewardship, transparency, and sustainability.
Equity: We believe in fairness and respect for all.
Inclusivity: We believe in engaging, embracing, and unifying our communities.
Innovation: We believe in continual adaptation of technology, process, and experience.
Hiring Process
Gwinnett County is an Equal Opportunity Employer. For more information regarding our hiring process, please click the links below:
Gwinnett County is committed to creating a diverse workforce. As an Equal Opportunity Employer, we prohibit discrimination on the basis of genetic information (including sex), race, color, national origin (including ancestry), gender (identity and expression), sexual orientation, age, marital status, familial status (including pregnancy), disability, military or veteran status, religion, political affiliation, immigration status, homeless status, or any other category protected by law.