Digital Technical Engineer - Data Workflows (Database)

JOB OBJECTIVE

Provide technical guidance and subject matter expertise in all aspects of database infrastructure. Work collaboratively with product owners, project managers, and application developers to develop efficient, configurable applications that leverage database functionality and application code

KEY ACCOUNTABILITIES

• Implement and manage database infrastructure in accordance with best practices and Injazat's security standards


• Ensuring the customer's solution is configured and technically deployed to specification, accurately, and on-time


• Implement database services for Cloud workloads (AWS, Azure, VMware, and G42 Cloud Platform)


• Perform Database Infrastructure assessments and deliver due diligence reports


• Develop migration planning, preparations, and cutover activities with internal and external teams


• Develop and maintain low level designs, system diagrams, installation configuration & guides, support procedures, test plans and runbook


• Installation, configuration, monitoring, and troubleshooting of non-clustered and clustered database systems (MS SQL, Oracle, PostgreSQL, MongoDB, etc)


• Provide database management services across multiple product lifecycle environments, from development to production systems in mission-critical environments


• Migrating databases from on-prem to cloud and vice versa, using open source tools and custom scripts where necessary


• Implement cross-platform data replication using open source vendor tools


• Develop, document, and implement Disaster Recovery Plan and execute DR drills


• Perform advanced problem determination and root-cause-analysis


• Providing hands-on technical expertise and technical guidance to staff, project leaders, and other teams as needed


• Providing end-to-end problem resolution by independently analyzing, solving, and correcting issues


• Maintaining data platforms through patching, indexing, and other operational maintenance activities


• Analyze SQL performance issues and recommend solutions


• Work collaboratively with peers to identify and remediate security and risk gaps


• Addresses database capacity issues, resiliency issues, stability issues, replication issues, and other key aspects of distributed databases


• Transition clients to Managed Services Support following successful implementation


• Review, analyze, and implement additional 3rd party software solutions and database add-on solutions as needed


• Examine tables in the database to establish knowledge of data for accurate retrieval and use in reports and other business processes
  


• Evaluates, researches, and recommends new technologies and services that improve operational efficiency and effectiveness in the role of DBA


• Identify, clarify, and resolve project activity issues and risks, escalating them as necessary


• Ensure compliance/alignment with our infrastructure by reviewing technical documentation; and if not, outline and prioritize tasks to ensure alignment before implementation


• Analyze and troubleshoot complex queries both internally and from vendors to ensure performance targets are achieved


• Maintain strong relationships with internal Application, Operating Systems, and Data and Technology Services teams


• Ensures compliance with change management and documentation policies


• Participate and respond to requests from Internal Audit, external auditors as directed by the management


• Take part in management-defined on-call rotations


• Researches and recommends solutions that best meet business needs and enterprise operational requirements


• Analyzes and implement new technologies, processes, tools, and techniques.


• Design and build databases for data warehousing, application development, and business intelligence


• Planning and implementing disaster recovery exercises as well as participating in performance discussions and capacity planning.


• Provides strategic and architectural support and evaluates products and services


• Coordinate with external vendors and internal stakeholders to ensure that the best solution is implemented.


• Defining project scope, plans, and deliverables, including costings and implementation dates


• Implement implementation milestones and goals by proactively consulting clients on best practices and system and process changes


• Manages, coordinates, and implements security measures, including application and security patches.


• Working closely with Technical Support staff and Implementation leadership to identify, analyze, and recommend solutions to client issues; Conducting thorough research, analysis, and recommendation.


• Enhances performance and provides increased functionality through continuous improvement efforts


• Maintains robust procedures and monitors the performance and reliability of databases


• Manage the development and maintenance of applications and systems in close cooperation with system administration and vendors.


• Providing technical mentorship and cross-training to other members of the team by sharing domain knowledge and technical expertise


• Plan and execute the Injazat Operation Readiness process for Infrastructure projects for transition into production support

SKILLS, EXPERIENCE AND QUALIFICATIONS:

• Bachelor's degree or equivalent in Computer Science or a related field or equivalent work experience


• Certification from database vendors such as Oracle, MySQL, MongoDB, PostgreSQL etc,


• ITIL foundation certification


• A minimum of 5 years' experience implementing and administering MSSQL, MySQL, Oracle, MongoDB, and/or PostgreSQL


• 5+ years of experience conducting architecture and design reviews, performance audits, and performance troubleshooting


• Implementation, maintenance, and architecture experience with SQL Azure


• A working knowledge and experience of cloud-based database tools and platforms


• Expertise in Oracle database, Exadata, OEM, and multi-tenant support/administration


• Knowledge of replication technologies such as Oracle Data Guard and Golden Gate


• Implementation and support of high availability disaster recovery plans


• Detailed knowledge of the concepts, features, limitations, and implementations of clustering


• Expertise in data automation, SQL performance tuning, and optimization


• A comprehensive understanding of the administration of complex 24x7 database environments, with expertise in troubleshooting, performance monitoring, upgrading, patching, backup/recovery, and cloning


• Having experience in data analysis, data profiling, data troubleshooting, and data reconciliation


• Migration experience from on-premises to the cloud


• Knowledge of backup solutions, performance tuning, query optimization, and index tuning


• Understanding of replication and experience with multiple high availability tools and methods


• The ability to talk at a low level about technical details or at a high level about strategy depending on the situation


• Understanding of cloud computing architecture, technical design, and implementations, including IaaS, PaaS and SaaS delivery models


• Knowledge of security hardening and system performance tuning


• Must be aware of Project Management and ITIL frameworks


• Solve problems quickly, effectively communicate solutions and associated risks


• Ability to clearly articulate concepts to people with varying technical background


• Work independently with minimal guidance on complex issues and projects