Citizen
Full Time
Direct Hire
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 26th Jul 2022
The Database Engineer is a senior technical member of the Midrange Database team, responsible for providing Subject Matter Expert (SME) expertise and direction on database platform technologies for the global K-C database environment. The Database Engineer guides long-term strategy for a global midrange database infrastructure that is highly available, secure, reliable, and cost-effective. The Database Engineer drives automation, develops and maintains database infrastructure scripts, provides troubleshooting assistance on advanced database performance issues and application issues, researches new database features and platforms, and serves as an escalation point for other database team members.
The K-C midrange database environment consists of 1,000+ database servers, globally located, which provide a highly available database platform for hosting K-C s in-house developed and purchased applications. The strategic midrange database platforms used at K-C and supported by the Midrange Database team are: Microsoft SQL Server, Azure SQL Database, Oracle database, and Snowflake.
Responsibilities
Design and implement enterprise scale database infrastructures for SAP and non-SAP applications
Provide operational DBA expertise on supported platforms maintaining a focus on availability, reliability and performance
Resolve complex, critical database performance issues and provide advanced troubleshooting guidance on application issues, working with DTS teams and external vendors. Document resolutions.
Design, develop and implement database infrastructure processes and scripts (including monitoring, backup and recovery, disaster recovery)
Drive automation/self-service opportunities in the database environment
Provide direction on tools used for database performance monitoring, troubleshooting, and tuning
Provide architectural guidance on long term DB roadmap vision, including hosting options, upgrades, patching
DB Architect for new midrange database platforms
Lead large FOAK efforts for new database features and integrated tools such as SQL AAG, replication
Identify database environment gaps and design new tools/processes to improve
Provide direction and support for database high availability solutions (including SQL AAG)
Mentor and educate midrange database team members, infrastructure peers and application support teams on DB processes and DB best practices
Knowledge share and build cross-team solutions with key DTS partners (Global web services, Cloud hosting, Backup Storage, Windows, VMWare, HANA DB, BI)
Ensure accurate database configuration items in CMDB
Provide direction on database environment to ensure a high-level of performance, including an understanding of underlying storage, OS, and servers
Perform limited DBA operational work
Ensure that all actions follow established internal controls and change management processes.
Participate in on call rotation for supported DB platforms
Required Qualifications
Bachelor s Degree in Computer Science or related field
Minimum of 7 years of experience as a Database Administrator or related database field experience in one or more of the following platforms: SQL Server, Azure SQL Database, Oracle database, Snowflake, SAP HANA database
Proficient in database application troubleshooting
Application development experience in one or more of the following: PowerShell, .NET, and SQL
Advanced knowledge of midrange server infrastructure - storage, operating systems, server architecture, server virtualization
Demonstrated experience in database platform upgrades, patch management, analyzing database query plans, and recommending SQL query performance improvement suggestions
Cloud database experience (Azure preferred)
Code deployment and lifecycle management experience; knowledge of DevOps practices
Experience collaborating with enterprise architects and Infrastructure engineers to identify, design, and implement highly complex, end-to-end solutions. Success in collaborating with blended teams consisting of employees, partners, vendors, and consultants across cultural boundaries
Strong leadership and service delivery skills; exhibit creative thinking to identify inventive solutions to solve business strategies
Self-motivated to keep up with industry trends and disseminating information across the team and customers
Preferred Qualifications
Experience with the following tools: Service-Now, Data Domain, CommVault
Experience with SAP systems
Experience with hybrid cloud automation using tools like Terraform, Ansible, etc.