Long Description

Job Summary

You will be responsible for architecting/implementing and maintaining the performance, integrity, and security of Infrastructure Cloud technologies and Data management using on-prem/cloud platforms.

Ensure that appropriate design and deployment plan executed for new business-critical applications. Perform data analysis to detect emerging trends and underlying service issues, make recommendations and help formalize data management, housekeeping, and archiving standards.

Job Responsibilities

•    Develop and implement technical efforts to design, build, and deploy AWS/Azure applications, including large-scale data processing, computationally intensive statistical modeling, and advanced analytics
•    Participate in all aspects of the software development life cycle for AWS/Azure solutions, including planning, requirements, development, testing, and quality assurance
•    Troubleshoot incidents, identify root cause, fix and document problems, and implement preventive measures
•    Educate teams on the implementation of new cloud-based initiatives, providing associated training as required
•    Employ exceptional problem-solving skills, with the ability to see and solve issues before they affect business productivity
•    Creates and maintains all databases required for development, testing and production usage for Alghanim Industries SAP systems
•    Manage a continuous integration and deployment methodology for server-based technologies
•    Provide and develop a level of expertise and solutions in; VMware, Linux, Storage Systems, Networking, ITIL, basic project management and Problem Solving
•    Managing Alghanim AWS/Azure Infrastructure Lifecycle.
•    Maintain data center environmental and monitoring equipment
•    Recommend process and architecture improvements in AWS and Azure
•    Performs ongoing tuning of the Oracle and SQL database instances
•    Troubleshooting systems Performance issues, fixing problems, and owning issues through to resolution
•    Plan and implements backup and recovery of the Business-critical systems
•    Control migrations of programs, database changes, reference data changes through the development life cycle
•    Manage disaster recovery and replication procedures along with Managed Service Provider
•    Excellent communication (written and oral) and interpersonal skills
•    Proven ability to work creatively and analytically in a problem-solving environment
•    Strong analytical, communication and organizational skills

Candidate Requirements

Education:
•    Bachelor’s Degree or qualified by experience
•    Oracle , Microsoft , VMware and ITILv3 certified , AWS Associate certificate
Experience:
•    Minimum 7 years’ experience in a similar role
Skills and Attributes:
•    5+ years of hands-on experience on Cloud Infrastructure implementation using Azure and AWS platforms.
•    Experience in designing and managing AWS and Azure infrastructure in line with business requirements.
•    Identify and implement the most optimal cloud-based solutions for the company
•    Define and document best practices and strategies regarding application deployment and infrastructure maintenance
•    Managing cloud environments in accordance with company security guideline
•    Experience in Oracle DBA support with various versions of the oracle, day to day administration, installation, configuration, troubleshooting, Monitoring, and Performance Tuning
•    Disaster recovery for the systems such as failing over and failing back business-critical services
•    Forecast data growth trends and optimize systems and databases performance
•    Good experience in Oracle 10g, 11g, 12c/MS SQL Server administration with solid skills in concepts and architecture and hands on experience on Oracle RAC databases / Microsoft SQL Server Databases
•    Hands-on VMware administration experience contributing to the successful design, development, implementation, change and release management.
•    Competent in developing documented process and adhering to Cloud and Database standards and best practices
•    Strong knowledge in Systems Performance and tuning.
•    Experience in different OS platforms and cross platform migration skills.
•    Ability to work independently in complex environments of multi-vendor systems
•    Able to provision Block storage for systems access in a VMware environment
•    Suse Linux 11/12 ,Shell scripting, Oracle virtual machine (OVM) , VMware
•    Promoting process improvement
•    Knowledge of ‘relational database management systems’ (RDBMS), ‘object oriented database management systems’ (OODBMS) and XML database management systems.

Education

Long Description

Job Summary

Oversee and manage various aspects of data integration and data warehouse processes. This includes implementing data quality measures, designing and deploying integration solutions, collaborating with team members, troubleshooting production issues, refining best practices, educating end users, participating in code reviews, exploring, and adopting new technologies, leading prototype development, and ensuring adherence to industry standards. The role involves working within Agile teams, reporting on project status, and partnering with IT Solution Architects to optimize data integration designs. The goal is to contribute to efficient and effective data analytics integration solutions while staying informed about technological trends and mentoring team members.

Job Responsibilities

Operational Work – 75% of time 

• Implement Data Warehouse data quality processes. Provide solutions where issues are identified
• Design, develop, test, and deploy data integration solutions based on business requirements
• Collaborate with team members on data integration designs and alternatives
• Troubleshoot and resolve production issues
• Continually refine and document data integration best practices
• Educate end users (where applicable) in the use of metadata and understanding where data originates
• Participate in code reviews
• Identify, evaluate, and refine leading-edge data integration tools and methods
• Build prototypes and POCs
• Bring a passion to stay on top of tech trends, experiment with and learn new technologies, participate in internal & external technology communities, and mentor other members of the engineering community
• Own the development of cross-functional, multi-platform prototypes
• Work within and across Agile teams to design, develop, test, implement, and support data analytics integration solutions
• Document and support deployment activities
• Report on status of IT Data Operations products and projects on a regular and timely basis
• Ensure the timely resolution of issues
• Follow standards and guidelines according to industry best practices
• Escalate anticipated risks to management promptly and properly
• Partner with IT Solution Architects regarding data integration design options

Strategic Work – 25%

• Educate and inform yourself and team members about data integration technology solutions and emerging trends
• Continually participate in visioning exercises and contribute to the data strategy

Candidate Requirements

Required years of relevant experience:

• 4+ years of experience designing, developing, and maintaining data integration solutions

Desired Qualifications:

• Education – B.S. in Computer Science or related discipline.
• Advanced degree a plus

Specialized Skills:

Required:

• Data integration development experience with the following skill sets:
• Extract, Transformation, and Load (ETL) of disparate data sources to targets including databases, files, and API’s. Talend, Matillion, Glue Data Studio preferred
• Ability to detect, identify and resolve source to target performance / load issues
• Expert level proficiency in structured query language (SQL)

o    Data Warehousing
-Thorough understanding of relational data models including third normal form and fact / dimension designs
-Change data capture (CDC) design options and application
-Data marts
o    Oracle database platform features including indexing, partitioning and PL/SQL
o    AWS Data Migration System (DMS), Amazon Redshift, Aurora Postgres Expertise including but not limited to performance tuning
o    Linux O/S commands and scripting
o    Secure File Transfer Protocol (SFTP)
o    Desire to work in the data integration space (data warehouse, data lake, AWS, data API’s) while continuing to grow skill sets

Desired:

• Modern development practices – e.g. DevOps
• Experience with open source database platforms:

– PostgreSQL
– MySQL
-MariaDB

• Data Lake integration design and development (ETL & ELT Methodologies)
• Experience with data quality tools
• Experience with AWS platform:

o    DMS
o    Glue
o    Redshift
o    S3, etc

• AWS Certifications
• Experience in API development
• Master data management integration and concepts
• Experience with job scheduling solutions such as Airflow

Education