Job Description
This large municipality is looking for a strong Sr. DBA Admin to manage database environments that include SQL, Oracle, DB2 and system specific (proprietary) databases. They will also ensure database systems run effectively and securely on a daily basis as well as Design, install, and maintain standards and manager SQL/Oracle databases. Ensure database data access, security, backup, and recovery. Schedule and carry out performance tuning and capacity monitoring of database systems. (Standby, failover, and administration.) Install, upgrade, and manage database server environments. Develop processes for optimizing database security. Diagnose and troubleshoot database errors. Recommend and implement emerging database technologies. Work with the data team to provide data for use by internal customers and data systems. Develop, test, improve, and maintain new and existing databases to help users retrieve data effectively and efficiently. Design, develop, implement and manage SQL server business intelligence solutions using SSIS and SSRS solutions. Create and manage database reports, visualizations, and dashboards. Identify and create automation for repeatable database tasks. Develop and maintain database documentation utilized by enterprise level and in-house developed applications. Identify and incorporate non-enterprise level databases into enterprise level database systems. This role will be hybrid, 3 days onsite and 2 days remote.
Required Skills & Experience
5+ years experience of responsible day to day operations with SQL Databases as well some exposure to Oracle databases with in large environments
Experience doing installation, configuration and curation of SQL Servers
any experience with Replication
Microsoft and Oracle Certified Database Administrator.
Experience supporting database environments within a local government/water utility.
Data warehousing and business intelligence experience.
Experience creating reporting environments from database sources. (SSIS packages and SSRS reporting.)
Nice to Have Skills & Experience
Experience securing SQL Servers
Any experience with prior local governments or utility companies
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.