Data Engineering Consultant - Multiple Locations (897788) Position Description Combine two of the fastest-growing fields on the planet with a culture of performance, collaboration and opportunity and this is what you get.
Leading edge technology in an industry that's improving the lives of millions. Here, innovation isn't about another gadget, it's about making health care data available wherever and whenever people need it, safely and reliably.
as well as data modeling, big data development, Extract, Transform, and Load (ETL) development, storage engineering, data warehousing, data provisioning and other similar roles.
Responsibilities may include Platform-as-a-Service and Cloud solution with a focus on data stores and associated eco systems.
Duties may include management of design services, providing sizing and configuration assistance, ensuring strict data quality, and performing needs assessments.
Analyze current business practices, processes and procedures as well as identifying future business opportunities for leveraging data storage and retrieval system capabilities.
Manage relationships with software and hardware vendors to understand the potential architectural impact of different vendor strategies and data acquisition.
May design schemas, write SQL or other data markup scripting and helps to support development of Analytics and Applications that build on top of data.
Select, develop and evaluate personnel to ensure the efficient operation of the function. Primary Responsibilities Requirement gathering and analysis, development, support, maintenance and implementation Participate in knowledge sharing sessions and impart the training to fellow team members Further build upon domain knowledge and technical / proprietary skills Guide new members in the team to help them scale up faster and performs other tasks as needed Install, migrate, upgrade and maintain multiple databases required for development, testing, and production environments Analyze and investigate Provide explanations and interpretations within area of expertise Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and / or re-assignment to different work locations, change in teams and / or work shifts, policies in regards to flexibility of work benefits and / or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment).
The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so Required Qualifications Undergraduate degree or equivalent experience 8 years of experience in database development and support in MS SQL Server environments Strong experience in Database Administration in SQL Server (2005, 2008, 2012, 2014 and 2016) Hands-on experience on any of the scripting languages like T-SQL, PowerShell, Python or Chef Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
approve complex structural changes to the database Ability to recommend database approaches and design to infrastructure and application teams SQL Development - Ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints) SQL Database Operational support to tech users Solid acquaintance with windows server, security delegation, SPNs, storage components Ability to lead the database administration team and interfacing with the project leader and project team, advising on the use of the database software, database design, functions, standards, installation and patching of the RDBMS, database creation in the development, testing and production environments, security and tuning Ability to make improvement and do maintenance of the databases to include rollout and upgrades Ability to do implementation and release of database changes Ability to do capacity planning for the high critical databases Ability to participate in 12x7 on call rotation Ability to prioritize and execute tasks in a high-pressure environment Ability to present ideas in user-friendly language Good understanding Forward thinking in the potential use of future technology Documentation skills for processes and procedures (creating KBs, runbooks, topology, etc.
Excellent interpersonal, verbal and written communication skills, as well as strong logical, analytical and problem-solving skills Self-motivated and directed, with keen attention to detail Preferred Qualifications Experience in SSRS / SSIS Knowledge of Python or Chef