Sr. IT Systems Admin
GWINNETT COUNTY
Lawrenceville, United States of America
5 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Senior Compensation
$ 113KJob location
Lawrenceville, United States of America
Tech stack
Azure
Databases
Database Servers
Microsoft Visio
Microsoft SQL Server
Oracle
Oracle Applications
Powershell
Recovery Manager (RMAN)
SQL Databases
Information Technology
Data Pipelines
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.
Public Speaking Duties
- 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
Requirements
- 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
Benefits & conditions
Pulled from the full job description
- Referral program
- Tuition reimbursement
- Parental leave
- Health insurance
- Vision insurance
- Health savings account
- Life insurance, The grade for this position is C451. Salary will be dependent on education and experience.
About the company
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.