Data Engineering Consultant
Optum Global Solutions ( India ) Private Limited
Hyderabad/Secunderabad | Noida/Greater Noida | Gurgaon | Bengaluru / Bangalore, INDIA
1d ago
source : TimesJobs

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.

  • There's no room for error. Join us and start doing your life's best work.(sm) Positions in this function may include database architecture, engineering, design, optimization, security, and administration;
  • 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.

  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools Expert experience in implementing operational automation Automation experience using DevOps methodology Experience working in a team-oriented, collaborative environment Prior experience with teams spread across multiple locations across multiple time zones Excellent technical troubleshooting and consultation with quality assurance and development teams Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication Strong knowledge of how indexes, index management, integrity checks, configuration, and patching work;
  • how statistics work, how indexes are stored, how they can be created and managed effectively Good knowledge of SSIS / SSRS / TSQL Good knowledge of Database Migrations (Homogenous & Heterogenous) Automation Mindset and good knowledge of Agile methodologies Knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs) Understanding of execution plans and how to use them to optimize / improve query costs, indexing Ability to help the team in technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database technology to the business opportunities facing the company Ability to coach, mentor, and hire appropriate resources to the team Ability to troubleshoot problems regarding the databases, applications and development tools Ability to detect and troubleshoot SQL Server related CPU, memory, I / O, disk space and other resource contention Ability to analyze and sustain capacity and performance requirements Ability to implement best backup and recovery strategies in the environment Ability to work with Architecture team to establish coding standards for stored procedures, triggers, logical and physical schema design;
  • 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

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form