Job Location: San Diego, CA
What a Senior Data Warehouse Engineer Does:
Under the direction of the IT Development Manager, the Senior Data Warehouse Engineer is responsible first and foremost for the administration and maintenance of the MS SQL Server database infrastructure and dependent systems. The position acts as the primary technical resource for database integrity, backup and restoration, and performance monitoring. In addition, the Senior Data Warehouse Engineer is responsible for the overall design, implementation, and maintenance of the Enterprise Data Warehouse (EDW). Essential duties and responsibilities of this position include, but are not limited to, the following:
Essential Functions
- Administers, monitors, maintains, upgrades and troubleshoots existing database infrastructure across development, testing and production database environments.
- Designs, implements and improves new database infrastructure components, applications, interfaces, replications, SSIS packages (ETL), stored procedures, etc. for both transactional and non-transactional databases.
- Develops, documents and maintains enterprise best practices standards and procedures for database creation, upgrades, patches, backups, restoration, replication, index maintenance, tuning, monitoring, alerting and security.
- Performs and monitors regular data imports from disparate internal and external systems, ranging from fully automated to manual processes, in order to meet the MTS operational reporting requirements.
- Performs required server and software patches in conjunction with Datacenter Operations schedules and System Administrators (may require occasional after-hours support).
- Establishes and maintains security and access controls for MTS database systems, applications, data, indexes, database services, replication packages and processes in conjunction with Datacenter Operations and System Administrators.
- Manages the data integrity and replication of databases, monitoring database health and security, tuning database objects, creating, documenting, and maintaining Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) code, systems and storage capacity planning.
- Plans, designs, builds, tests, implements, and troubleshoots complex data warehouse systems utilizing dimensional designs and schemas.
- Creates and executes complex Structured Query Language (SQL) queries to retrieve data and create views for both customers and developers.
- Follows processes and procedures for creation of Key Performance Indicators (KPIs) for the organization.
- Designs, implements, and maintains both transactional and non-transactional databases.
- Integrates data between various data sources and databases including but not limited to: Transactional and Non-Transactional SQL Server Databases,Oracle Databases,Vendor-hosted Cloud Databases, SAP ECC databases, SQL Azure Databases,Excel Spreadsheets, Files (e.g. Excel, .csv).
- Creates Data Warehouse Roadmaps, Dataflow Diagrams, Entity Relationship Diagrams (ERD)s, Schema Diagrams, Data Dictionaries, and other Technical Documentation as required.
Duties May Include, But Are Not Limited To, The Following:
- Designs, implements and maintains high availability database architecture.
- Maintains business critical replication infrastructure, including legacy systems.
- Designs and executes database queries and data analysis in response to requests from MTS departments.
- Creates and maintains documentation for the Enterprise Data Warehouse (EDW) databases, database infrastructure and database processes and procedures.
- Collaborates with IT staff and MTS departments in the design, development, tuning and troubleshooting of database infrastructure, services, servers and applications.
- Performs other duties as assigned.
What MTS is Looking For:
Knowledge, Skills and Abilities
Knowledge of or ability to learn MTS policies and regulations; ability to read, understand and apply MTS policies, regulations and union labor contracts; ability to write letters, memoranda and reports using clear, concise and grammatically correct English; ability to speak clearly, distinctly and effectively in person-to-person or small group situations using tact and diplomacy; ability to coordinate and initiate actions necessary to implement decisions and delegate responsibilities to appropriate personnel; ability to establish and maintain priorities in order to complete assignments by deadlines without detailed instructions; skill in verifying the accuracy and completeness of forms and reports; knowledge of Microsoft Word and Excel and the ability to learn and use other software that MTS might have or acquire; exceptional verbal and written communication skills; ability to clearly communicate complex technical concepts to individuals or groups with varying technical understanding; exceptional organizational, prioritization and multi-tasking skills; exceptional interpersonal skills and understanding of customer relationship management; exceptional collaborative and team-centric working style; good stress-management coping skills and ability to work well under pressure.
Special Skills/Knowledge
- Knowledge of MS SQL 2008/2012/2014/2016/2019 RDBMS and MS Windows Back Office systems.
- Knowledge of T-SQL and writing and maintaining scripts and queries.
- Knowledge of MS SSIS, DTS, triggers and stored procedures.
- Knowledge of reporting tools, in particular MS SSRS and Business Objects.
- Knowledge, of Extract Transform Load (ETL) and Extract Load Transform (ELT) processes utilizing tools such as SQL Server Integration Services (SSIS).
- Knowledge of Enterprise Data Warehouse concepts, MS SQL Server enterprise database administration standards, processes and procedures.
- Knowledge of enterprise MS SQL backup and disaster-recovery processes, procedures, policies and best practices (experience with CommVault desirable).
- Knowledge of MS SQL Server performance tuning, and the design and implementation of high availability database architecture.
- Familiarity with MS development technologies, C#, ASP.NET and web technologies, HTML, Javascript, CSS, XML, etc. is highly desirable.
- Knowledge of data modeling — normalization, schemas (star and snowflake), facts, dimensions.
- Knowledge of SQL Azure and extension of On-premises environments to the cloud is highly desirable.
- Knowledge of SAP is a plus.
Physical Requirements
The successful candidate must be able to fulfill the physical demands of the job such as walking, stooping, sitting, bending, reaching for overhead files and occasional lifting (must be able to lift up to 15 pounds). Must be able to operate a motor vehicle and perform tasks involving manual dexterity, such as use of a computer and 10-key. Work will at times require more than 8 hours per day or an irregular work week to perform the essential duties of the position. Duties will be performed primarily in an office type environment and may require travel to external locations and agencies. Must be able to work on-call.
Experience/Education/Certificates/License(s)
Possess a bachelor’s degree from an accredited college or university in Computer Science, Information Technology, Management Information Systems or related field. Must have a minimum of five (5) years of experience administering MS SQL server databases in an enterprise environment. Prior experience as the technical lead in administering, configuring, monitoring, tuning and troubleshooting mission-critical database infrastructure is required. Must possess and maintain a valid California driver’s license.
Current Certifications in one or more the following are highly desirable:
- Microsoft Certified Database Administrator (MCDBA) (Legacy)
- Microsoft Certified Solutions Expert (MCSE): Data Platform
- Microsoft Certified Solutions Master (MCSM)
GENERAL:
Must satisfactorily pass all applicable examinations including, but not limited to, a pre-employment physical, drug screen and background check.
SALARY RANGE:
#11 ($84,899 – $166,022)*
- Hiring Range is usually mid-range & DOQ
DISCLAIMER: The above described job elements are intended to indicate the general nature and levels of work being performed by employees assigned to the job. They are not intended to be an exhaustive list of duties, responsibilities and skills required of employees so classified. Management retains the discretion to add to or change the duties of the position at any time.
QUALIFICATIONS:
Knowledge, Skills and Abilities
Knowledge of or ability to learn, understand and apply all of the MTS policies and regulations, as well as union labor contracts; ability to write letters, memoranda and reports using clear, concise and grammatically correct English; ability to speak clearly, distinctly and effectively using tact and diplomacy in both interpersonal and small group situations; ability to initiate, coordinate and negotiate sharing of tasks to achieve goals; ability to establish and maintain priorities in order to complete assignments by deadlines without detailed instructions; skill in verifying the accuracy and completeness of forms and reports; knowledge of Microsoft Word, Excel, PowerPoint and Access and the ability to learn and use other software that MTS might have or acquire; exceptional verbal and written communication skills; ability to clearly communicate complex technical concepts to individuals or groups with varying technical understanding; exceptional organizational, prioritization and multi-tasking skills; exceptional interpersonal skills and understanding of customer relationship management; exceptional collaborative and team-centric working style; good stress-management coping skills and ability to work well under pressure.
Special Skills/Knowledge
- Knowledge of MS SQL 2008/2012/2014 RDBMS and MS Windows Back Office systems.
- Knowledge of T-SQL and writing and maintaining scripts and queries.
- Knowledge of MS SSIS, DTS, triggers and stored procedures.
- Knowledge of reporting tools, in particular MS SSRS and Crystal Reports.
- Knowledge, design and support of Extract Transform Load (ETL) processes.
- Knowledge of Enterprise Data Warehouse concepts, MS SQL Server enterprise database administration standards, processes and procedures.
- Knowledge of enterprise MS SQL backup and disaster-recovery processes, procedures, policies and best practices. (Experience with CommVault desireable)
- Knowledge of MS SQL Server performance tuning, and the design and implementation of a high availability database architecture.
- Familiarity with MS development technologies, C#, ASP.NET and web technologies, HTML, Javascript, CSS, XML etc. highly desirable.
- Knowledge of Oracle 11g highly desirable.
- Knownledge of SAP systems highly desirable.
Physical Requirements
Candidates must be able to perform the physical demands of the job, such as walking, bending, stooping, sitting, reaching for overhead files and occasional lifting (must be able to lift up to 15 pounds), operating a motor vehicle and performing tasks involving manual dexterity, such as use of a computer and 10-key. To perform the essential duties of the position, work may at times require more than 8 hours per day and/or irregular hours. Duties will be performed primarily in an office type environment, but travel to external agencies may be required. Must be able to work on-call.
Experience/Education/Certificates/License(s)
Possess a bachelor’s degree from an accredited college or university in Computer Science, Information Technology, Management Information Systems or related field. Must have a minimum of 5 years of experience administering MS SQL server databases in an enterprise environment. Prior experience as the technical lead in administering, configuring, monitoring, tuning and troubleshooting mission-critical database infrastructure is required. Must possess and maintain a valid California driver’s license.
Current Certifications in one or more the following are highly desirable:
- Microsoft Certified Database Administrator (MCDBA) (Legacy)
- Microsoft Certified Solutions Expert (MCSE): Data Platform
- Microsoft Certified Solutions Master (MCSM)
- Oracle Database 11G Administrator Certified Professional
GENERAL:
Must satisfactorily pass all applicable examinations including, but not limited to, a pre-employment physical, drug screen and background check.
SALARY RANGE:
#10 ($74,148 – $121,474)
#facebookad
Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled
Submit CV To All Data Science Job Consultants Across United States For Free
