System One
Lead Database Admin
System One, Broken Arrow, Oklahoma, United States, 74012
Overview
Applying for this role is straight forward Scroll down and click on Apply to be considered for this position.The position plays a focal role maintaining data platforms and database development. The position will lead in planning, evaluating, and selecting the right database platform to host data for specific use case. As part of a highly collaborative team, the role will interact with many technical and business resources across the enterprise.The ideal candidate is a committed, creative, self-motivated technologist who is interested in practicing his or her skills and learning new ones.
Primary Duties and Responsibilities Provide technical and policy leadership to data platform administratorsGuide and mentor teammates to follow best practices and align with IT strategyImplement best practices and security standards on the data platforms that support enterprise products and servicesAuthor SOPs, configuration specifications and related technical documentationContribute to improving and creating data platform policies, procedures, and operational standards, as well as documenting the current data storage landscapeMaintain an in-depth understanding of KPIs related to Service Level AgreementsResponsible for documentation standards and automation across the database services spaceContribute to plans and road map for patching, security, audit, capacity, products, and future enhancementsProvide technical leadership to support databases on Oracle, MySQL, PostgreSQL, MS SQL Server, and Azure Cloud Services ADF, Databricks, ADLS, Cosmos Db (Mongo DB API), and Key Vault, and Replication tools SQDR, Simplement, and HVRPlan, design and build HA and DR for enterprise data platformsSupport the future direction of modern data platform and migrationsProvide guidance on CI/CD process for the databases, tools, and products mentionedSupport systems integrity and audit objectives.Audit and continuously monitor the current environments to meet the standards and complianceDrive adherence to service management support processes (ITSM, Incident, Problem, Change, and RCA processes)Monitor performance issues on all production and non-production databases (as applicable) implementing performance monitoring and trending on all production and applicable non-production databases with tools.Create run books and knowledge baseContinuously improve database and Database Administration services to provide 24 x 7 world-class support.Work collaboratively with colleagues to develop enterprise database strategies for High Availability and Data Safeguarding.Collaborate with Data, Application, and Infrastructure Architects to ensure optimal enterprise solutionsComplete other tasks as required
Experience, Education and Skills 8+ years of working in Information Technology8+ years of DBA experience in any of the following: MS SQL Server, Oracle, MySQL3+ years DBA Experience on NoSQL databases – Document, Graph and Timeseries3+ years of DBA experience of cloud databases like SQL MI, Cosmos DB, Databricks and understand the performance implications3+ years of experience in supporting BI and Analytics workloads – Azure Data Factory, SSIS, Azure Databricks, Azure Analysis services, Power BI
3+ years' experience in SQL development and performance tuningWorking knowledge of Change Data Capture (CDC)Strong experience modeling Relational, Dimensional, and unstructured dataAbility to communicate and execute new concepts, ideas, techniques, best practices, policies, and technologyMust have a thorough understanding of security practices such as LDAP, SSL, SSO, and certificate managementExperience with ITSM methodologies preferred.Proven work ethic with the utmost integritySelf-awareness, with a desire for constant self-improvement (goal-oriented)Personality traits for successful individuals may include self-motivated, passionate, empathetic, approachable, energeticExperience with agile methodologies: SCRUMBachelor's degree from an accredited institution or equivalent industry experience.
General Requirements Provide leadership responsibility of the deliverable outcomes of Data platform Services teamExhibit and practice courteous, ethical, and professional behavior while interacting with both internal and external customersIdentify and develop talented engineers and leaders, foster a healthy and collaborative culture for your team that embodies industry best practices and company valuesOwnership and accountability over creating new systems, supporting, and evolving existing systemsInfluence/make technology decisions for the platform at enterprise levelAct in a collaborative, team-oriented environment focused on common goals to achieve mutually beneficial resultsBe accountable and responsible for the accuracy and completeness of assigned work and resultsPrioritize and manage workload and communicate issues clearlyExhibit effective verbal and written communication skillsComply with all laws, regulations, and company policiesTravel when required
Applying for this role is straight forward Scroll down and click on Apply to be considered for this position.The position plays a focal role maintaining data platforms and database development. The position will lead in planning, evaluating, and selecting the right database platform to host data for specific use case. As part of a highly collaborative team, the role will interact with many technical and business resources across the enterprise.The ideal candidate is a committed, creative, self-motivated technologist who is interested in practicing his or her skills and learning new ones.
Primary Duties and Responsibilities Provide technical and policy leadership to data platform administratorsGuide and mentor teammates to follow best practices and align with IT strategyImplement best practices and security standards on the data platforms that support enterprise products and servicesAuthor SOPs, configuration specifications and related technical documentationContribute to improving and creating data platform policies, procedures, and operational standards, as well as documenting the current data storage landscapeMaintain an in-depth understanding of KPIs related to Service Level AgreementsResponsible for documentation standards and automation across the database services spaceContribute to plans and road map for patching, security, audit, capacity, products, and future enhancementsProvide technical leadership to support databases on Oracle, MySQL, PostgreSQL, MS SQL Server, and Azure Cloud Services ADF, Databricks, ADLS, Cosmos Db (Mongo DB API), and Key Vault, and Replication tools SQDR, Simplement, and HVRPlan, design and build HA and DR for enterprise data platformsSupport the future direction of modern data platform and migrationsProvide guidance on CI/CD process for the databases, tools, and products mentionedSupport systems integrity and audit objectives.Audit and continuously monitor the current environments to meet the standards and complianceDrive adherence to service management support processes (ITSM, Incident, Problem, Change, and RCA processes)Monitor performance issues on all production and non-production databases (as applicable) implementing performance monitoring and trending on all production and applicable non-production databases with tools.Create run books and knowledge baseContinuously improve database and Database Administration services to provide 24 x 7 world-class support.Work collaboratively with colleagues to develop enterprise database strategies for High Availability and Data Safeguarding.Collaborate with Data, Application, and Infrastructure Architects to ensure optimal enterprise solutionsComplete other tasks as required
Experience, Education and Skills 8+ years of working in Information Technology8+ years of DBA experience in any of the following: MS SQL Server, Oracle, MySQL3+ years DBA Experience on NoSQL databases – Document, Graph and Timeseries3+ years of DBA experience of cloud databases like SQL MI, Cosmos DB, Databricks and understand the performance implications3+ years of experience in supporting BI and Analytics workloads – Azure Data Factory, SSIS, Azure Databricks, Azure Analysis services, Power BI
3+ years' experience in SQL development and performance tuningWorking knowledge of Change Data Capture (CDC)Strong experience modeling Relational, Dimensional, and unstructured dataAbility to communicate and execute new concepts, ideas, techniques, best practices, policies, and technologyMust have a thorough understanding of security practices such as LDAP, SSL, SSO, and certificate managementExperience with ITSM methodologies preferred.Proven work ethic with the utmost integritySelf-awareness, with a desire for constant self-improvement (goal-oriented)Personality traits for successful individuals may include self-motivated, passionate, empathetic, approachable, energeticExperience with agile methodologies: SCRUMBachelor's degree from an accredited institution or equivalent industry experience.
General Requirements Provide leadership responsibility of the deliverable outcomes of Data platform Services teamExhibit and practice courteous, ethical, and professional behavior while interacting with both internal and external customersIdentify and develop talented engineers and leaders, foster a healthy and collaborative culture for your team that embodies industry best practices and company valuesOwnership and accountability over creating new systems, supporting, and evolving existing systemsInfluence/make technology decisions for the platform at enterprise levelAct in a collaborative, team-oriented environment focused on common goals to achieve mutually beneficial resultsBe accountable and responsible for the accuracy and completeness of assigned work and resultsPrioritize and manage workload and communicate issues clearlyExhibit effective verbal and written communication skillsComply with all laws, regulations, and company policiesTravel when required