Job Description :
Client : Direct
Title : Database Administrator - V
Location : Chandler AZ
Duration : 9+ Months
Pay Rate : Negotiable
Description
Design, plan, test, integrate, implement and maintain Data Science platform for Decision Engineering. May have responsibility for administering several aspects of a project such as access methods, system allocation, and security. Provides technical assistance in identifying, evaluating, and developing systems and procedures. Assignments may include design of analytic and database systems; to include layout, installing, upgrading, and managing. May work in teams with other Engineers, Data Analysts, Application Developers, System Architects, and IT staff.
Provides the engineering required to ensure a stable, highly available, and optimally tuned Data Science Platform through application and system-level configuration, including troubleshooting, performance tuning and capacity planning and management for systems across Decision Engineering
Performing deployment and upgrade efforts and execute tasks related to these projects, on time while in compliance with adopted Intel policies and standards.maintaining high quality standards Providing monitoring to engineering analysis tools to achieve optimum performance and high availability. Design and implement data strategies for high availability
Qualifications
BA/MS in CS or IT. Minimum 9 years of DBA experience with SQL Server and NoSQL databases, HadoopVery good knowledge and hands-on installation, configuration and troubleshooting any platform related issue on standalone and clustered environment. Experience in performance tuning and point in time recovery, refresh non-prod environment with PROD copy are required.
Added advantage for candidates having knowledge on open source databasesStrong knowledge of Query Optimization techniques. Tune indexes, triggers, stored procedure, views, partitions.
Proficiency Expertise in Programming in codes languages [T-SQL, PL/SQL, SQL], C#, Python and R
Experience with SQL Server high availability DR solutions like clustering, AlwaysOn, database mirroring, log shipping, replication, and partitioning.
Experience with DevOps automation tools, including Chef, Puppet, or Ansible
Fluency in common query languages, API development, data transformation, and integration of data streams.
A working knowledge of code and script - Python and/or Ruby, Shell, Logstash
Responsible for designing, deploying, and maintaining computing platforms that enable large scale data analysis
Identifies gaps and improves the existing platform to improve quality, robustness, maintainability, and speed.
Evaluates new and upcoming big data solutions and makes recommendations for adoption to extend our platform to meet advanced analytics use cases, such as predictive modeling and recommendation engines.
Experience in ML Model design and implementation
Monitors and improves environment to maximize compute efficiency and minimize cost.