The Database Administrator provides the principal capability within the organization to store, organize, and maintain the security of customer and production data.
The Database Administrator is responsible for the design, architecture, implementation, performance, security, and maintenance of all data storage for the organization and our clients. The role will interact regularly with the Lead Application Developer, internal client account managers, SAS analytics team members, and production facility managers.
The Database Administrator also provides the primary report writing capability within the organization for production management reporting and data extraction activities.
Essential Duties and Responsibilities:
Lead the installation, configuration, design, and testing of new client-focused databases supporting data-related activities. Design and implement the databases required to support client and production functions. Identifies user requirements, sets up database structure, tests, and coordinates modifications to these systems.
Creates and maintains data loads from external clients via SSIS and manipulates data via a strong knowledge of SQL stored procedures.
Implement database performance monitoring, mapping of conceptual designs, refining logical designs, data modeling, maintaining data standards and protection (encryption), writing database documentation (standards, procedures, definitions), defining access control and permissions, managing backup and recovery paths, and participating in capacity planning.
Perform "ad hoc" data retrieval, assembly, and reporting functions for delivery to internal and external teams. Create data views to support the internal SAS Analytics team.
Provide ongoing maintenance of all organizational production and administrative data sources to ensure data integrity and database security. Troubleshoots database errors, indexing, speed, or other concerns. Coordinates with the Sr. Director, Technology and Lead Application Developer to ensure all data storage and retrieval capabilities are properly supported and maintained within our IT infrastructure.
Produces and maintains database documentation (e.g. data dictionary, Entity Relationship Diagrams) as required for proper system maintenance and system enhancements.
Other duties as assigned.
Qualifications, Education and/or Experience:
Bachelor's Degree in Computer Science or related field; or five to seven years related experience; or equivalent combination of education and experience.
Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
Certificates, Licenses, Registrations:
MCSE: Data Platform Certification desired, but not required
Other Skills and Abilities:
Comprehensive knowledge of database administration
Comprehensive knowledge of structured query language (SQL)
Comfort with both on-prem and cloud-based SQL deployments
Comprehensive knowledge of data analysis, modeling, and database design techniques
Comprehensive knowledge of SQL Server Integration Services (SSIS)
Skill in performing complex and specialized database functions
Skill in performing indexes and stored procedure tuning; handling security, backups and recovery
Skill in evaluating changes in the production environment and anticipating resources needed to meet those changes.
Experience with reporting tools (SQL, Reporting Services, and Crystal Reports)
Experience with high availability, fault tolerance, and disaster recovery
Comprehensive experience using SQL Server Management Studio
High motivation to deliver a quality product on time, every time
Ability to work in a fast-paced environment and handle rapidly-changing work requirements
Ability to consistently use team project and collaboration software tools
Strong organizational skills, including the ability to continually prioritize work to meet changing work conditions and customer requirements
Ability to work independently against project milestones to achieve objectives with minimal supervision
Excellent communication skills
Excellent mathematical skills
We offer an excellent pay and benefits package including: Medical, dental, and vision insurance; short & long term disability; 401(k) with a generous company match; life insurance, profit sharing, paid time off, 8 paid holidays and much more! Baesman has been in business for over 60 years and is a PIA Best Workplace in America award winner