Do you thrive on ensuring smooth data operations and enhancing database performance? We're in search of a talented Database Administrator to join our team, where you'll oversee multiple applications and streamline data exchange across internal and external platforms. Don't wait any longer – apply now and be part of our dynamic team!
ONLY LOCAL APPLICANTS AS THIS IS A HYBRID POSITION!
Database Administrator Job Description
The Database Administrator role will be responsible for supporting multiple applications and data transformation between internal and external applications. The successful candidate will have hands-on experience in a multitude of domains; including, but not limited to; 24 x 7 x 365 enterprise and cloud database infrastructure design and management, security, business continuity, disaster recovery, database design, database development, database tuning, enterprise data storage and backup, service delivery, incident tracking, change management, and general database administration. The DBA should be proficient in the development of stored procedures, triggers, and packages. The candidate must be a team player, willing to provide constructive feedback and guidance to technical staff as well as contribute to the continuous improvement of our software development processes and approach.
Essential Functions:
- Monitor database performance and optimize the database for efficiency and scalability.
- Develop and implement database backup, periodical database audits, and recovery strategies.
- Maximize performance through effective hardware recommendations, and server configuration changes.
- Tune queries and index updates to improve performance.
- Monitor system health, diagnose and resolve database performance issues.
- Keep software and patches up-to-date, and perform upgrades when necessary.
- Ensure data integrity, and implement and maintain database security policies, procedures and access controls.
- Assist with capacity planning, and forecast future database requirements.
- Produce documentation for database designs, how-to articles, configurations, processes, and procedures.
- Provide on-call support for database-related emergencies and after-hours server patch updates.
- Make suggestions regarding database design, tuning options, and other potential issues.
- Manage all database instances across development, QA, staging, and production. environments, handling installation, configuration, and maintenance.
- Develop reports using SSRS.
- Extract, load, and transformation data via SSIS.
- Collaborate with technical and business teams to optimize database structures, reports, queries, and procedures.
Qualifications
- Bachelor’s degree with major course work in information systems, computer science, or a related field, or equivalent experience
- Five (5)+ years of database administration for Microsoft SQL Server
- 2+ years of Azure SQL database operations background strongly preferred
- Knowledge of Blue Yonder and Dynamic Great Plains database preferred