SQL Database Developer

1 week ago

Columbus, United States Baesman Group, Inc. Full time
Job DescriptionJob Description

Baesman Group, a nationally recognized provider of direct-to-customer marketing strategy and multi-channel execution is seeking an experienced SQL Database Developer to join our Information Technology Team. The SQL Database Developer works within a small IT Team to serve internal and external clients for customer loyalty and engagement programs, operations/manufacturing systems, and in-house/custom-built applications.

The Database Developer role provides the principal capability within the organization to design, create, modify, maintain/monitor, secure, and optimize database structures including tables, indexes, views, and stored procedures. Other critical duties include daily complex ad-hoc query writing, SQL job monitoring and processing, ETL development, report writing, and MS BI management.

The SQL Database Developer also provides the primary report writing capability within the organization for production management reporting and data extraction activities from various systems (both internal and external) and helps facilitate data-based quality control efforts for data coming in to, and out of, our and our client’s systems.

The ideal candidate will have excellent communication skills and be a fast learner. Because of the role’s requirement for daily interaction with the Lead Application Developer, internal teams of account managers and data analysts, and directly with external clients, speaking fluent English is required, as are strong personal/professional skills. The role is expected to be able to interact in meetings, ask good questions, learn quickly, and be on-camera when working remotely.

This is a hybrid role with two days spent in our Columbus, OH headquarters, and the remaining three days in a work-from-home remote setting.

Essential Duties and Responsibilities:

1. 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.

2. Create and maintain data loads from external clients via SSIS and manipulate data via a strong knowledge of ETL/SSIS and SQL stored procedures.

3. Complete daily complex "ad hoc" queries and report requests for delivery to internal and external teams. Create and maintain data views to support the internal SAS Analytics team.

4. 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.

5. 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.

6. Produce and maintain database documentation (e.g. data dictionary, Entity Relationship Diagrams) as required for proper system maintenance and system enhancements.

7. Lead the discovery, mock-up, creation, testing, scheduling, and ongoing revision of SQL/SSRS-based business reports.

8. Maintain multiple SQL server instances including SQL and OS versions, compatibility, upgrades, working with external vendors to ensure functionality, etc.

9. Other duties as assigned.

Requirements

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.

Reasoning Ability:

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 is desired, but not required.

Other Skills and Abilities:

· Mastery of database administration and development.

· Mastery of structured query language (SQL), SSIS, SSRS, ETL, and report writing.

· Mastery of creation and ongoing management of stored procedures and SQL scripting.

· Comprehensive knowledge of database security, backups, and recovery.

· Comfort with both on-prem and cloud-based SQL deployments.

· Comprehensive knowledge of data analysis, modeling, and database design techniques.

· Skill in performing complex and specialized database functions.

· Experience with Snowflake and MS Azure is a plus.

· Skill in evaluating changes in the production environment and anticipating resources needed to meet those changes.

· Strong experience with reporting tools (SQL, SSRS, Crystal Reports, BI, etc.)

· Experience with high availability, fault tolerance, and disaster recovery.

Other Qualifications:

· Ability to speak fluent English.

· Ability to learn quickly, use ticketing systems effectively, and communicate thoroughly.
· High motivation to deliver strong results on fixed timelines.

· Ability to work in a fast-paced environment and handle rapidly changing work requirements and priorities.

· Ability to consistently use team project and collaboration software tools including Jira, MS Teams, etc.

· 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 and reasoning skills.

· Excellent mathematical skills.

Benefits

Financial wellness is about more than just your salary. Here are the other ways Baesman Takes care of our teammates.

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 a fourth-generation, family-owned business. In the same way families grow and change over time, so do the opportunities within our organization. We believe in hard work, cultivating talent, and promoting from within. We strive to help our teammates, our clients, and our shareholders achieve more than they thought possible.

Baesman is an Equal Opportunity Employer.

  • SQL Database Administrator

    2 weeks ago

    Columbus, United States Saxon Global Full time

    **Candidates must be located within a commutable distance of the central Ohio area. ***This is a contract-to-hire opportunity and will convert to a full-time position within 3-6 months. Our client is looking for a mid to senior-level SQL DBA to join their technical team, assisting the Senior DBA with all responsibilities that include but are not limited...

  • SQL Server Database Administrator

    3 weeks ago

    Columbus, United States Cyborgwave Full time

    Job DescriptionJob DescriptionOverview:The SQL Server Database Administrator plays a critical role in ensuring the performance, integrity, and security of the organization’s databases. They are responsible for the implementation, maintenance, and support of SQL Server database systems, ensuring their availability and optimal performance.Key...

  • SQL Server Developer

    5 months ago

    Columbus, Ohio, United States Infoprompt Inc Full time

    Seeking a skilled SQL Server Developer through Knowledge Services with a broad breadth of technical experience. As a part of the application development team making modifications to or creating new components for application processes the Developer will participate in activities related to the creation and/or modification of processes for backend database...

  • Senior Database Developer

    2 weeks ago

    Columbus, United States Emerald Resource Group Full time

    Job Title: Senior Database Developer Location: Cleveland, OH, United States *Note: This role is not available for sponsorship*Job Description: We are seeking a highly skilled Senior Database Developer to design, develop, document, implement, and maintain database solutions in support of web applications, with a strong focus on Oracle database applications,...

  • SQL Developer

    2 weeks ago

    Columbus, United States Saxon Global Full time

    Duties and Responsibilities: 5+ years of experience with supporting On-Prem & SaaS applications utilizing SQL server databases. Must possess strong knowledge in Stored Procedures, SSIS, and writing and tuning of queries Vendor Application Support - Releases, Patches, and Incident Support API (SOAP and REST) development and management for both On-Prem...

  • HR Manager

    3 months ago

    Columbus, Ohio, United States Integration Developer Network Full time

    Provides development expertise and supports the infrastructure (.NET Applications MS-SQL databases and Windows Servers) for all applications focusing on the Health Services Planning Unit (HSP) applications. Design develop test and implement enterprise-strength C#/.Net Web applications and database queries. Modifications and enhancements for HSP web...

  • Database Systems Engineer

    7 days ago

    Columbus, Ohio, United States Baesman Group, Inc. Full time

    Job DescriptionOverviewBaesman Group, Inc. is seeking an experienced Database Systems Engineer to join our Information Technology Team. As a key member of our team, you will be responsible for designing, creating, modifying, maintaining, and optimizing database structures to support our business operations.Key ResponsibilitiesDesign and implement database...

  • Database Architect Supervisor

    1 week ago

    Columbus, Ohio, United States Central Ohio Transit Authority Full time

    Job SummaryWe are seeking a highly skilled Database Architect Supervisor to join our team at Central Ohio Transit Authority. As a key member of our IT department, you will be responsible for designing and administering our database resources to ensure efficient use throughout the organization.Key ResponsibilitiesSupervise and lead a team of database...

  • Database Architect Supervisor

    1 week ago

    Columbus, Ohio, United States Central Ohio Transit Authority Full time

    Job Summary:Central Ohio Transit Authority (COTA) is seeking a highly skilled Database Architect Supervisor to lead the design and administration of our database resources. As a key member of our IT team, you will be responsible for ensuring the integrity and security of our data, as well as providing technical support for efficient use throughout the...

  • Sr .Net Full Stack Developer with SQL, Python

    1 month ago

    Columbus, United States Technovision Inc Full time

    Our direct client is looking for a Sr .Net Full Stack Developer with SQL, Python for a Hybrid Long-term contract position in Columbus, Ohio. Note: Hybrid 2days/week JOB DESCRIPTION: - Client is seeking for an experienced, skilled, motivated senior Full Stack web application developer with specialization in API integration for developing both front-end...

  • Data Engineer

    3 months ago

    Columbus, United States Nexient Full time

    **Data Engineer (SQL Server, Power BI, SSIS, SSRS)** Columbus, OH / Delivery Practice AI/ML/Data Engineering / Full-time **Role and Responsibilities:** + This data engineer should have exceptional SQL Server programming skills as follows + Needs to have advanced Business Intelligence experience + BIML scripting + SSIS, SSRS, SSAS + Power BI + Excellent...

  • Informatica Developer

    5 days ago

    Columbus, Ohio, United States Stellar Professionals Full time

    Job DescriptionJob Title: Informatica DeveloperJob Type: Long-term ContractCompany: Stellar ProfessionalsJob Summary:We are seeking a highly skilled Informatica Developer to join our team. As an Informatica Developer, you will be responsible for designing, coding, and modifying ETL processes using Informatica PowerCenter 10.x.Key Responsibilities:ETL Design...

  • Data Warehouse Developer

    4 weeks ago

    Columbus, Ohio, United States codesbright Full time

    Responsiblties Gather and document business data requirements into data models and database designs. Work with project leads in analyzing system requirements and specifications and translating those requirements into database designs. Understand business requirements and perform data analysis estimation database programming testing and implementation. Ensure...

  • ETL developer

    3 months ago

    Columbus, United States Inforites LLC. Full time

    Background BWC is looking for a TS3 to support implementing a Data Lake Operational Data Store and Data Marts for Business Reporting. Data sources will include a variety of Relational Databases and Semi-structured data. Both ETL and ELT jobs will be designed developed and tested to move data from these sources into the analytical databases Snowflake and...

  • Sr Power Bi Developer

    2 months ago

    Columbus, Ohio, United States Atechstar Full time

    Responsiblties Perform requirement analysis and review related to database enhancements for enterprise-level clients. Design and develop SQL data warehouse solutions for effective reporting and analysis using SQL Server Analysis Services and Tableau Develop reports/dashboards using SQL Server Reporting Services Tableau and MS Power BI Design develop optimize...

  • ETL developer

    3 months ago

    Columbus, Ohio, United States Inforites LLC. Full time

    Background BWC is looking for a TS3 to support implementing a Data Lake Operational Data Store and Data Marts for Business Reporting. Data sources will include a variety of Relational Databases and Semi-structured data. Both ETL and ELT jobs will be designed developed and tested to move data from these sources into the analytical databases Snowflake and...

  • Expert C# Developer

    2 weeks ago

    Columbus, Ohio, United States Focused HR Solutions Full time

    Focused HR Solutions is seeking a highly skilled C# Developer to join our client's team in Columbus, OH. This is an exciting opportunity for a talented individual to contribute to the development and maintenance of cutting-edge software applications. In this role, you will be responsible for designing, developing, and implementing robust and scalable...

  • Sr Web Application Developer

    5 days ago

    Columbus, United States Snapx Full time

    Development experience usin Angular and Web Forms/MVC 5.0 framework in .NET & ASP.NET environment with proficiency in C# Java Script CSS and jQuery Designing & implementing user interfaces using modern web technologies such as HTML5CSS3 and JavaScript frameworks like React Angular or Vue.js Hands on experience with markup languages Angular 8 and above...

  • Oracle EBS Developer

    3 weeks ago

    Columbus, United States Stellar Professionals Full time

    Job DescriptionJob DescriptionTitle: Oracle EBS Developer Work Arrangement: OnsiteJob Description:We are looking to fill a Long-term Contract role as Oracle EBS Developer in Columbus, OhioMode of Interview: In person Applicants must have a minimum of 5 years of relevant experience with the following:SQL, PL/SQL, SQL Loader, SQL Plus and SQL DeveloperOracle...

  • .NET FullStack Developer

    1 month ago

    Columbus, United States Software Technology Inc Full time

    Job DescriptionJob DescriptionTitle: Programmer 5 ( Sr. Web Application Developer)Location: Columbus, OHDuration: 9 MonthsHybrid 2days/weekJob Description:13 Years in development experience using Angular and Web Forms/MVC 5.0 framework in .NET & ASP.NET environment with proficiency in C#, Java Script, CSS, and jQueryDesigning & implementing user interfaces...