Product Specialist (SQL Server DBA) - Diversified Systems, Inc.
Columbus, OH 43215
About the Job
Product Specialist – SQL Server DBA
Remote (for now)
Description:
DSI is searching for a SQL Server resource who will be responsible for managing Microsoft SQL Server Database environments including on the SQL Server databases virtual machine (VM) servers. They will ensure best practices in database planning, design, configuration, performance and capacity planning and growth ensuring our SQL databases offer the highest reliability and performance possible. They will work with the DBA ITM1 to ensure that team goals and metrics are met.
Responsibilities:
Requirements:
About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.
Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.
Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.
Remote (for now)
Description:
DSI is searching for a SQL Server resource who will be responsible for managing Microsoft SQL Server Database environments including on the SQL Server databases virtual machine (VM) servers. They will ensure best practices in database planning, design, configuration, performance and capacity planning and growth ensuring our SQL databases offer the highest reliability and performance possible. They will work with the DBA ITM1 to ensure that team goals and metrics are met.
Responsibilities:
- Should be able to provide DBA support for distributed servers in a multi-datacenter environment.
- Monitor daily activities and performance of complex SQL environment, analyzes technical problems, recommend adjustments, creates, and implements approved solutions using
- established tools and techniques.
- Provide technical assistance to the application development area and co-workers about SQL design and programming.
- Configures SQL services (e.g. security, JDBC, clusters). Plans, installs, and coordinates SQL Server releases, migrations, upgrades, and maintenance. Build new environments as needed to support applications.
- Coordinating with the teams of network, IIS administrators and storage groups for SQL server-based configurations.
- Develop technical documents, project plans and tasks, interact with customers for proposed solutions.
- Provide non-production and production support for deploying code and assist in trouble shooting and resolving application issues.
- Support DevOps tools (Ansible, Jenkins, Nexis, Mavin, Bitbucket, Kony Mobile, Nginx etc.).
- Any other tasks assigned by the management team based on project/application needs.
- Provide technical Tier III support, develops project plans with project manager, or recommends approach through defining tasks.
- Leading meetings relating to design, implementation, operation, and ongoing maintenance of databases systems.
- Designs/plans of cluster nodes hardware selection and recommendations, configures/sets- up cluster nodes, sets-up interconnects, and configures cluster- aware storage; installs cluster and database management system (DBMS) software on all
- nodes.
- Monitoring load balance and tunes cluster parameters for high performance, configuring standby servers.
- Configuring and implements log shipping, configures, and implements replication etc.
- Provide technical leadership that fosters database innovation and champions automation.
- Support strategic planning for database architecture, resource management, and capacity planning and growth.
- Ensures best practices in database planning, design, configuration, performance, and resilience.
- Evaluate and proposes design and process improvements to achieve performance and cost optimization.
- Identify inefficiencies in current database designs and oversees the implementation of improved solutions.
- Plans and implements capacity and resource expansion to ensure scalability of databases.
- Implements effective risk management controls and owns adherence to all compliance related items (exceptions, waivers, risks, technical compliance, and access control)
- Leads incident resolution efforts and engages appropriate resources to complete corrective actions as quickly as possible.
- Conducts research and provides recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
- Virtualized Infrastructure running various Unix, Linux, and AIX operating systems.
- Altering storage structures to meet the evolving needs of the Organization.
- Regularly updating the database security protocols, patching.
- Provides leadership and work guidance to less experienced personnel.
- Will also work with project management to support and ensure timely and effective client
- communications about deployments and upgrades.
Requirements:
- 9+ years experience.
- 4 year college degree or equivalent technical study.
- SQL Server DBA certification is preferred.
About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.
Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.
Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.
Source : Diversified Systems, Inc.