What are the responsibilities and job description for the Database Administrator position at Diversified Systems.com?
Remote
Local to Harrisburg PA preferred
Description:
Diversified Systems is searching for a Database Administrator to provide advanced technical support across all phases of database administration, database development, database operations, data migration, and enterprise database management activities. This position is responsible for supporting critical production systems and ensuring the availability, performance, security, and reliability of database environments, including Azure SQL and SQL Server platforms.
Responsibilities:
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.
Local to Harrisburg PA preferred
Description:
Diversified Systems is searching for a Database Administrator to provide advanced technical support across all phases of database administration, database development, database operations, data migration, and enterprise database management activities. This position is responsible for supporting critical production systems and ensuring the availability, performance, security, and reliability of database environments, including Azure SQL and SQL Server platforms.
Responsibilities:
- Provide operations support for SQL Database and Database Server administration for critical production systems.
- Ensure overall health, availability, and quality of database services.
- Perform health checks to review database performance and provide recommendations for performance improvements.
- Perform migration and upgrades of SQL databases from legacy servers and SQL versions to new server and SQL versions.
- Perform data migration activities by designing programs to extract, cleanse, transform, load, and validate data between source and target systems.
- Deploy SQL database solutions within Azure environments.
- Secure Azure SQL resources and data.
- Provide database design support.
- Define, develop, and create databases by assessing business and technical requirements.
- Meet with developers and vendors to gather requirements and provide consulting support for database configurations.
- Deploy and maintain database schema changes across test and production environments.
- Provide technical support for Data Warehouse, Data Mart, and Power BI environments.
- Deploy, configure, secure, back up, and maintain Azure SQL database solutions.
- Integrate Azure SQL resources with other Azure services to support enterprise applications and data solutions.
- Monitor, troubleshoot, and optimize Azure SQL and SQL Server database performance and availability.
- Support migration of on-premises SQL Server databases to Azure SQL.
- Design, develop, and maintain logical and physical database models based on business and technical requirements.
- Review and validate data models and data dictionaries to ensure compliance with organizational standards.
- Develop and maintain database structures, including tables, relationships, and normalization, to ensure data integrity, efficiency, and minimal redundancy.
- Collaborate with developers, business stakeholders, and vendors to gather requirements and recommend appropriate database architectures and configurations.
- Coordinate database backup and restore requests with backup administration teams.
- Participate in ongoing process improvement initiatives.
- Apply data analysis and database management techniques to support enterprise solutions.
- Work independently with minimal supervision.
- Determine time estimates and schedules for assigned work.
- Identify and track issues, risks, and action items.
- Coordinate with vendors and service providers to resolve technical support issues.
- Assist in coordinating software releases.
- Manage and provide status updates on assigned work activities.
- Follow established database standards and procedures.
- Work effectively within a team environment.
- Complete assigned tasks and project deliverables.
- 7 years of SQL Server Database Administration experience required.
- 4 years of experience performing database administration on production servers required.
- 3 years of Data Analytics experience required.
- 1 year of Azure Database Administration experience required.
- 1 year of Data Warehouse experience required.
- Excellent communication skills required.
- Ability to provide high-quality and professional customer service required.
- Power BI Administration experience highly desired.
- Business systems analysis and design experience highly desired.
- Microsoft SQL High Availability (HA) and Always On experience highly desired.
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.