Description:
*** Very long term project; Initial PO till for 2 years - expect to go for 3+ years *** Initial remote due to covid then onsite; candidate must pick up the laptop in person before remote work ***
**Full time with benefits or hourly contract position*** Need 3 verifiable references with resume
We are looking for an experienced database administrator who will be responsible for leading the efforts to ensure the performance, availability, and security of Oracle, MySQL and MS SQL databases. This position will be the lead DBA for our agency and lead all database upgrades and projects for Oracle and SQL. This positions goal is the deployment of sustainable and modern database technologies, on prem and in cloud based. The candidate will have full control over the database technologies used as well as creating a future roadmap for all database technologies at the agency. This position will reside on the systems engineering team with a dotted line to the application architect and development teams. Day-to-day 50% operations and 50% planning and designing future state. This role will also handle orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams in the information technology division, preparing documentations and specifications as needed.
REQUIREMENTS:
- Bachelors degree in Computer Engineering or Computer Science or equivalent work experience - Required 5 Years
- Familiarity with Oracle database design, coding, and documentation. - Required 5 Years
- Knowledge of database backup procedures, recovery systems, and SQL. - Required 5 Years
- Knowledge of programming languages and API.- Required 5 Years
- Excellent communication and problem-solving skills. - Required 5 Years
- Proficient installing, configuring, maintaining and upgrading Oracle and SQL databases - Required 5 Years
- Proficient installing, configuring, maintaining and upgrading Linux based database servers - Required 5 Years
- Altering storage structures to meet the evolving needs of the company. - Required 5 Years
- Setting up database user accounts - Required 5 Years
- Experience interacting with users and customers regularly - Required 5 Years
- Training users on how to access the information in the database. - Required 5 Years
- Finding and debugging malfunctioning programs affecting the database integrity. - Required 5 Years
- Experience with monitoring Database capacity and performance - Required 5 Years
- Experience with applying security patches and subsequent testing - Required 5 Years
- Ability to refresh or clone databases from production to development - Required 5 Years
- Experience using stored Procedures, Functions, Triggers and packages - Required 5 Years
- Experience provisioning Microsoft SQL server instances - Required 5 Years
- Experience with Microsoft SQL server clusters - Required 5 Years
- Experience with AppDynamics or other performance monitoring tool - Required 5 Years
- Experience provisioning MySQL instances - Desired 5 Years
- Experience with using a SIEM / Log aggregator - Desired 5 Years
- Experience backing up and cloning databases using NetApp SnapCenter - Desired 5 Years
- Understanding of MySQLs underlying storage engines - Desired 5 Years
- Experience writing XML scripts per the customer requirements - Desired 5 Years
- Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, - Desired 5 Years
- Proficient understanding of code versioning tools such as {{Git / Mercurial / SVN}} - Desired 5 Years
- Experience with MariaDB and associated technologies - Desired 5 Years
- Experience with Azure SQL always on - Desired 5 Years
- Experience DB2 database technologies - Desired 5 Years
- Experience working in a DevOps environment - install and configure Sonar, Git, Jenkins - Desired 5 Years
- Experience administrating Microsoft Windows Servers - Desired 5 Year
- Experience with Alfresco Enterprise Content Management solutions - Desired 5 Years
- Experience working with Atlassian products (JIRA, Confluence, Bit Bucket) - Desired 5 years of experience.
- working with Business Objects (SAP) - Desired 5 Years