SQL Database Administrator

March 10

Baesman Group

WebsiteLinkedInAll Job Openings

We Get Personal.

Analytics & Customer Insights • CRM Strategy • Loyalty Marketing • Multi-Channel Execution • Email Marketing

51 - 200

Description

• Lead the installation, configuration, design, and testing of new client and production-focused databases supporting all data-related activities. Identifies user requirements, sets up database structures, tests, and coordinates modifications to these systems. • Create and maintain data loads from external clients via SSIS and manipulate data via a strong knowledge of ETL and 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 ad-hoc 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 VP, Technology, and Lead Developer to ensure all data storage and retrieval capabilities are properly supported and maintained within our IT infrastructure. • Produce and maintain database documentation (e.g. data dictionary, Entity Relationship Diagrams) as required for proper system maintenance and system enhancements. • Leads the discovery, mock-up, creation, testing, scheduling, and ongoing revision of SQL/SSRS-based business reports. • Maintain multiple SQL server instances including versions, compatibility, upgrades, working with external vendors to ensure functionality, etc. • Other duties as assigned.

Requirements

• Bachelor’s degree in computer science or related field; or five to seven years related experience; or equivalent combination of education and experience. • MCSE: Data Platform Certification is desired, but not required. • Comprehensive knowledge of database administration. • Comprehensive knowledge of structured query language (SQL), SSIS, SSRS, ETL, and report writing. • 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. • Strong experience with reporting tools (SQL, SSRS Reporting Services, and Crystal Reports). • Experience with high availability, fault tolerance, and disaster recovery. • Comprehensive experience using SQL Server Management Studio and related SQL tools (RedGate, etc.).

Benefits

• Medical Insurance- Choose between 3 medical plan options. We also offer dental and vision coverage, in addition to pre-tax flexible spending plans. • Profit-Sharing- Share in Baesman’s success. We also offer a 50% matching 401(k) program for up to 6% of your pay. • Paid Time Off- It’s important that you take time to recharge. That’s why we offer PTO, holiday breaks, and employee assistance programs. • Life and disability Insurance- We have you covered: Baesman pays 100% of the premium for life and disability. • On-site workout facility, wellness initiatives, and more. • Setting the Standard- Baesman earned a 2020 Best Workplace in the Americas designation from the Printing Industries of America. The prestigious award recognizes our efforts in providing an outstanding work environment. We’re honored and proud to be recognized. • Baesman is an Equal Opportunity Employer.