Data Engineer

Job Description:

• Manage Database Team located in multiple locations
• Handle projects driven by both Offshore & Onshore
• Distribute Work and project tasks
• Track projects and daily tasks
• Manage patch deployments and upgrades following best practices and provide capacity planning expertise
• Provide administration of development database environments including UAT, Processing, Development and QA based Oracle RAC database
• Perform security implementation in both OS and Database level of production servers ensuring several standard policies and compliances (HIPAA, SOX, PHI)
• Support the business to provide logistic support to Analytics, Production Engineers, Project Managers and Developers
• Working with a distributed team of IT and DBA resources to collaborate effectively with internal and external stakeholders to ensure that Vertica database platforms are highly available, optimally configured and efficiently managed
• Maintain Production servers and minimize downtime and tuning performance of database instances
• Plan for System change and implement
• Provide support to Business during Release process.
• Perform short- and long-term system/database planning and analysis including capacity planning, storage performance, system performance and database performance
• Daily use of SQL, PL/SQL,T-SQL performance tuningsoftware installation, configuration, upgrade and maintenance activities
• High Availability (HA) and Disaster Recovery (DR) options

Required Knowledge, Skills, and Abilities

• Implementing and maintaining large scale OLTP and OLAP systems in mission critical environments
• Information security standards including database system hardening, identity management and database access controls
• Should have knowledge of MS SQL & Oracle
• Should have knowledge of Linux and Windows OS.
• Should have experience in SQL
• Knowledge of Shell, Perl, bash Scripting language
• Administer custom engineered Oracle ExaDATA based Oracle Database software technologies
• Working knowledge of MS SQL Cluster
• Able to support 24X7 Production environment

PREFERABLE SKILLS

• Knowledge of and demonstrable capability in scripting, experience in writing Python/PowerShell or similar scripts
• Experience with Atlassian suite of tools (Jira, Confluence, Bamboo, Crucible, ITIL)
• Other databases technologies like Vertica.

Knowledge of Cloud

SOFT SKILLS

• Ability to work independently or as part of a team
• Persuasive in both written and verbal communication
• US Healthcare experience would be added value

Education + Experience

• Bachelor’s degree or equivalent degree in CS, IT, software or computer engineering, CIS, or any related field of study
• 10 + years of experience AS DATABASE Administrator in Oracle and MS SQL

Job Description:

Hands-on technical role to support our audit team through client data conversion and the support, development, and delivery of audit tools and reports. Ideal candidate combines experience with Microsoft Access application development VBA, Project management, Comfort with very large datasets (preferably SQL server) and business understanding to mine data and automate workflows focused on identifying anomalies and errors in our client’s business transactions.

Essential Functions:

Perform complex data mining, forensic analysis and aggregation; commingle multiple datasets to develop a streamlined, efficient representation of transaction lifecycles. Data mining for advanced analysis of data; presented in reports and/or interactive auditing tools Collaborate with business process owners to identify opportunities; define business requirements, design solutions to map to and in support of new or existing business processes and / or workflows.

Rapidly implement technical solutions designed to maximize operational efficiency and productivity. Perform Data validation to ensure accuracy and quality of data Large volume data conversion, data cleansing, production report generation, and upholding scheduled data delivery standards. Full life cycle project ownership from analysis to development to delivery of audit solutions. Contribute to documentation initiatives as needed Contribute to group knowledge and best practices Interacts with Auditors and other end users, other analysts and management, Corporate Functions

Key Responsibilities:

• Strong analytical/problem solving skills, Strong communication skills, ability to translate end user needs into an IT solution, Excellent organizational skills and attention to detail is critical to the success of all candidates.
• Ability to recognize inefficiencies in processes (operational or technical) and the ability to design solutions to address these issues Mastery working with large datasets
• Knowledge is extended to the development of solutions for a business area. Contributes to cross- departmental strategy and solutions. May lead teams
• Demonstrates mastery of a wide application of professional principles, theories and concepts. Troubleshoots and provides solutions for unusually complex problems.
• Solutions are imaginative, thorough and practicable. Contributes to the development of new and innovative solutions.
• Demonstrates self-reliance by (on occasion) working without appreciable direction toward long-range goals and objectives. Assignments may be self-initiated and agreed upon with management.
• Determines and pursues courses of action necessary to obtain desired results.
• Contributes to the productivity of the organization through the completion of projects associated with departmental objectives.
• Impact of decisions can be broad depending on the number of projects affected and may impact departmental resources, timeframes and budgets.
• May be a primary point of contact with vendors and consultants engaged in supporting the work activities of the group.
• Communicates formally and informally to management. May also conduct briefings and participate in meetings with internal and external partners or collaborators
• Owns communication between RCA client service delivery teams and analysts. Owns performance and quality of applications and data for client support systems.
• Influences design and development of new software products or major enhancements to existing software for clients and business partners.

Required Knowledge, Skills, and Abilities

• Experience developing and/or maintaining applications in Microsoft Access and VBA Advanced SQL Server skills – SQL Query Development and Performance Tuning (DBA Experience also helpful)
• Extensive experience with relational databases RDBMS (Microsoft, Oracle, MySQL, PostgreSQL)
• Experience with scripting languages (VBScript, PowerShell) preferred
• Experience working with ETL processes
• Retail analytics support or direct retail experience is preferred
• Skilled in Agile and SCRUM development methodologies (Kanban)
• Excellent communication skills
• Mentors and coaches problem solving and troubleshooting
• Experience in project management is a plus

Education + Experience

• BS / MS / Equivalent Training / Certification and 5+ years of relevant experience

Job Description:

• Taking ownership of complex databases (SQL, NoSQL, Columnar, In-memory types of dbs)
• Upgrades version of MySQL db (from v5.7 to v8.0)
• Mapping out and documenting data relationships
• Creating and managing backup, restore, user access policies
• Enforcing standards, process, and SLAs
• Leading database change management processes and supporting CI/CD processes from a database perspective
• Working with data engineers to manage data flows between multiple storage sources
• Advising developers on data storage aspects of building robust, scalable applications
• Performance tuning of databases and SQL queries
• Automating processes and creating maintenance plan for multiple database environments
• Performing proactive database administration Occasional on-call duties

Required Knowledge, Skills, and Abilities

• Have done database administration in a GCP environment
• Strong understanding of MySQL database security management
• Proficiency in writing SQL queries and stored procedures
• Proficiency in SQL query tuning
• Excellent documentation skills
• Record of emphasizing cross-functional teamwork
• Experience in Data Modeling, ETL/ELT workflow management
• Strong knowledge of operating systems, Shell/Python scripting is a big plus
• Nice to have: DataStore, BigQuery, Cloud Composer/Airflow, remote work experience

Education + Experience

• 5+ years of MySQL database administration experience