$100K — $150K *
The team is looking to bring on a team of Database Developers to support the Data and Analytics (D&A) team with a ServiceNow migration from current various data platforms. The project will involve recoding approximately 500 SQL Stored Procedures and Views as well as recode 1,500 + metrics and measures to align with ServiceNow data.
Database Developer will lead the planning, analysis, design, implementation, maintenance, and control of the organization's server-class databases. Handles and leads various large-scale or highly complex data/database management activities including one or more of the following: designing highly complex logical and/or physical databases; leading highly complex data modeling, mapping, integration, and capacity planning efforts; developing management policies, procedures and standards; and business requirements identification, analysis and development. Provides mentoring, guidance and general oversight to less experienced staff in a variety of database design, administration and/or modeling activities.
MINIMUM POSITION QUALIFICATIONS
6-8 years of database design and administration experience.
6-8 years of SQL experience
7+ years of experience writing relational database queries for stored procedures, query optimization and performance tuning
6 + years of experience supporting or designing complex ETL jobs using SSIS (SQL Server Integration Services)
4+ years in the implementation of Data quality checks, business rules, sanity checks
Experience Analyzing and resolving data quality issues and responding to process errors.
Performs ad-hoc requests for data manipulations, imports, exports, and updates
Design and develop SQL stored procedures to automate various workflows and/or optimize application performance
Experience in troubleshooting and performance tuning code within the database like stored procedures, views, triggers, partitioned objects, table relationships and hierarchies
Experience with Hadoop (Hive and HBASE)
Experience in writing optimized queries, views and triggers for integration with other applications
Strong analytical skills with high attention to detail and accuracy excellent verbal, written, and interpersonal communication skills
Strong time management skills and ability to meet deadlines
Knowledge and understanding of relational databases
Experience working with ServiceNow
The team is migrating current data sets and extracting from various platforms to ServiceNow. The team is looking for candidates who have expertise in database design and development in SQL.
Job Key Words:
Valid through: 11/9/2021