Digital Technical Engineer Data Workflows (database)
Year Chennai, Tamil Nadu, India
Job Description
b'
Overview: 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. Researches and recommends solutions that best meet business needs and enterprise operational requirements. Analyzes and implement new technologies, processes, tools, and techniques. Responsibilities:
- Implement and manage database infrastructure in accordance with best practices and Injazat\xe2\x80\x99s security standards
- Ensuring the customer\xe2\x80\x99s 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
- Plan and execute the Injazat Operation Readiness process for Infrastructure projects for transition into production support
- Ensure new knowledge is captured and shared
- Serve as a subject matter expert (SME)
- Share knowledge and enter data into knowledge repositories and build/harvest/leverage/re-use knowledge.
- Participate in supporting the project scope, gather client requirements, manage/align resources, manage communications
- Identify project tasks/activities and develop project schedules.
- Collaborate with team members and project stakeholders
- Effectively communicate project objectives and goals
- Complete project activities on time, within budget and within scope
- Develop implementation plans
- Create accurate operating procedures , support instructions, and operational/system documentation
- Solicit feedback from client on quality of product/solution
- Solve problems quickly, effectively communicate solutions and associated risks
- Manage expectations and meet deadlines
- Maintain utilization rates as per target
- Ensure that Injazat Operation Readiness Process for Infrastructure projects is planned and executed to transition projects into support. OR activities are within the baseline project schedule and OR is accepted into operations constrained within the scope of the project.
- Develop Low Level Designs and Implement Systems following Injazat Standard Builds and Security compliances.
- Obtain positive project references from clients. (e.g) Emails from Client, Reference letters signed from clients and Case studies completed with clients
- Support establishment of new solutions and services.
- 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
Beware of fraud agents! do not pay money to get a job
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.
Related Jobs
Job Detail
-
Job IdJD3035694
-
IndustryNot mentioned
-
Total Positions1
-
Job Type:Full Time
-
Salary:Not mentioned
-
Employment StatusPermanent
-
Job LocationChennai, Tamil Nadu, India
-
EducationNot mentioned
-
ExperienceYear