Locations : Janesville Headquarters; Remote; 400 Midland Ct; Janesville, WI 53546, USA
Purpose : The Database Administrator role is responsible for providing operational database services to the organization.
Responsibilities
- Owning, tracking, and resolving database related incidents and requests.
- Assisting developers in optimizing SQL code and stored procedures to ensure optimal database performance.
- Develop ETL processes and provide data to reporting infrastructure.
- Develop and review service-related reports (database backups, maintenance, monitoring and performance) on a daily basis to ensure service-related issues are identified and resolved within established SLAs.
- Responding to database related alerts and escalations and work with database engineering to come up with strategic solutions to recurring problems.
- Initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established time frames.
- Continued self-development in order to understand latest database advancements.
- Attend mandatory meetings and trainings, work scheduled overtime with minimal notice, and perform other duties as assigned per business needs.
Qualification Requirements
Must be at least 18 years of age.Able to read, write and speak English.Successfully pass and maintain acceptable background checks and security clearances.Bachelor's degree plus 3-5 years of experience providing end-user technical support preferred.3 to 5 years working with open-source relational database platforms such as MySQL, PostgreSQL and / or non-Relational such as MongoDB or Cassandra.Experience with Microsoft SQL Server a plus.Experience in performance tuning, query optimization, using performance monitoring and other related monitoring and troubleshooting tools.Ability to detect and troubleshoot database related CPU, memory, I / O, disk space and other resource contention.Working knowledge of backup and recovery procedures.Knowledge of indexes, index management, integrity checks, configuration, and patching.SQL development – ability to write and troubleshoot SQL and PL / SQL code and design (stored procedures, functions, tables, views, triggers, indexes, constraints).Ability to write ETL packages and convert data for use in SSRS Reports.Ability to work with Infrastructure and Virtualization staff on the performance of hardware and virtual components across CPU, memory, and back-end storage environments to provide optimum hardware and operating system selections.Solid acquaintance with Linux server, LDAP and storage components.Excellent verbal and written communication skills.Strong project management—develop and manage project plans identifying tasks, timelines, and resource staffing to meet deadlines; ensure projects stay on track and within budget.Focus on managing and resolving issues in alignment with SLAs.Occasional night and weekend availability for changes and support as needed.Travel (infrequent) as needed.Education
Experience
Licenses & Certifications
Equal Opportunity Employer / Protected Veterans / Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
J-18808-Ljbffr