```Overview```
With
a team, this role focuses on creatio
analysis
- orrect
- , and reporting
- data from enter
- se-wide SQL databases. The
- 7 production env
- nment contains multipl
- QL database in
- nces which fo
- hold and suppor
- ore internal function
- cross multiple b
siness lines. The
idate wil
- ocus on Ad-hoc a
- batch q
- ies to support end
r, external customer
- an array of data automation and propagation. On call support (e
ings and weekends) as pa
of a rotating schedule is required.
```Responsibilities```
* Create and maintain a variety of SQL queries, Stored Procedures, Triggers and SQL
* Generate extracts of specific formatted data sets as requested
* Assist in planning data or schema changes
* Ensure ongoing data quality with monitoring, sanity checks, and other QA tool
* Synchronize data between source, repository and warehouse/datamart instances
* Work with production backups for DR/recovery to support other environments
* Be a resource for others to optimize queries, answer questions, and troubleshoot database related concerns
* Take ownership of reported data problems, work to ensure resolution of source data as well as occurances
* Propose creative and feasible alternatives when confronted with new problems.
* Assist in off-hours production support coverage with other members of on-call teams as needed.
* Incorporate various external data sources, such as manual and automated CSV, XML, SOAP, etc
```Qualifications```
* Hands-on experience with MSSQL 2019 and higher, 2023 preferred
* Proficiency with SQL Server Management Studio
* Knowledge of troubleshooting real-time MSSQL instances for performance or logic flaws. Preference towards experience with high-availability data center, or data services companies
* Prior experience supporting a data-driven web environment - HTML, ColdFusion,ASP.NET, VB.NET.
* Experience with SAP Crystal Reports or SSI/Dashboard is desirable
* Ability to identify, track, and successfully resolve issues in an n-tier architecture.
* Familiarity with DOS batch file generation and running SQL code from DOS.
* Ability to multitask, self-motivate, and produce results without direct supervision.
* Professional level of interaction across various departments especially in keeping confidential information
```Education and Experience```
* BS in Computer Science, Computer/Electrical Engineering, Information Sciences or equivalent education.
* Minimum 4 years paid experience in software development (must be with SQL database) or 2 years in a database programming or DBA/scripting position.
* 1+ years experience creating and maintaining complex stored procedures, triggers and SQL batch code.
* Working knowledge of Windows Server 2019 and up.
If you are a dedicated Programmer with a passion for coding and a desire to contribute to the success of our organization, we encourage you to apply.
Job Type: Full-time
Pay: $55,000.00 - $65,000.00 per year
Benefits:
* 401(k)
* 401(k) matching
* Dental insurance
* Employee assistance program
* Health insurance
* Health savings account
* Life insurance
* Paid time off
* Retirement plan
* Tuition reimbursement
* Vision insurance
Experience level:
* 4 years
Schedule:
* Monday to Friday
* On call
* Weekends as needed
Ability to Relocate:
* Westerville, OH 43081: Relocate before starting work (Required)
Work Location: In person