Sr. SQL Server DBA/Architect - Central Point Partners
Independence, OH 44131
About the Job
Job Description - SQL Server
DBA/Architect
Advizex is a leading information technology provider of infrastructure and enterprise application solutions. Advizex combines the technical expertise of our consultants with the technologies from our strategic business partners to solve information technology issues impacting our clients' businesses.
POSITION
We are seeking a SQL Server DBA/Architect to join our Managed Services practice. As a member of this practice, you will communicate and consult with our client's business and technical personnel, blending with their IT team and working together to help identify potential problems and develop solutions. Candidate should be highly experienced with Microsoft SQL Server administration and database systems architecture. This position will focus on database expertise in both development and production support roles.
SUMMARY OF RESPONSIBILITIES
The successful person for this role will be highly experienced in SQL Server administration. They must have experience with:
• Performing DB environment health check / assessment
• Creating and maintaining high performance, scalable, and stable data architectures
• Leading database solution aspects including setting standards and providing deep technical expertise for best practices, systems, and architectures
• Design database architectures and solutions that are highly available and meet disaster recovery requirements
• Ability to identify gaps and risks with database strategy and security
• Effective capacity planning that can scale
• Database software lifecycle management (Patches and Upgrades)
• Design automated deployment procedures for on-premises and cloud
• Ensure successful delivery of solutions, training, and documentation, internally and with customers
• High-Availability design and builds using technologies SQL Server Failover Clusters
• Database, system, and application performance tuning
• Replication and Cloning Design and Solutions
• Backup recovery plans and execution
EXPERIENCE REQUIREMENTS
SQL Server DBA that has the following skill sets:
A minimum of 5 years database administration and design experiences with the following is required:
• Demonstrated experience in architecture of enterprise level database solutions
• Demonstrated experience with presentations in front of customers and management
• Excellent multitasking skills and task management strategies
• Ability to complete milestones and work toward multiple deadlines simultaneously
Advizex
• Ability to compile and organize statistical information and present findings to management
• Experience with cloud services (e.g., AWS, Azure, HPE Greenlake) is a plus
• Experience with SQL migrations on-prem and cloud
• Provide 24x7 support
• Participate in an on-call rotation
• Monitor system's health and performance
• Performance troubleshooting and resolution
• Analyze, solve, and correct issues in real time
• Handling daily issues (Blocking, long running Transactions, Deadlocks, etc.)
• Troubleshoot issues related to TempDb, Transaction log and System databases
• Knowledge of SSIS, SSRS (Definite Plus)
• Experience with backups, restores and recovery
• Scheduling database backups, taking full and Transaction log backups.
• Automate SQL server tasks (SQL jobs, Windows scripts, etc.)
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Excellent written and verbal communication
• Flexible, team player, "get-it-done” personality
• Ability to work in a rapidly changing environment
Experience identified below are additional positives:
• Familiarity with Oracle
• Familiarity with Open Source (e.g., MySQL, PostgreSQL)
• Supporting multi-site environment
• Experience with virtualization technologies
• Experience with Nagios, and scripting associated with plugin development
• Experience with using ServiceNow
• Experience with Logic Monitor
• Previous MSP experience
DBA/Architect
Advizex is a leading information technology provider of infrastructure and enterprise application solutions. Advizex combines the technical expertise of our consultants with the technologies from our strategic business partners to solve information technology issues impacting our clients' businesses.
POSITION
We are seeking a SQL Server DBA/Architect to join our Managed Services practice. As a member of this practice, you will communicate and consult with our client's business and technical personnel, blending with their IT team and working together to help identify potential problems and develop solutions. Candidate should be highly experienced with Microsoft SQL Server administration and database systems architecture. This position will focus on database expertise in both development and production support roles.
SUMMARY OF RESPONSIBILITIES
The successful person for this role will be highly experienced in SQL Server administration. They must have experience with:
• Performing DB environment health check / assessment
• Creating and maintaining high performance, scalable, and stable data architectures
• Leading database solution aspects including setting standards and providing deep technical expertise for best practices, systems, and architectures
• Design database architectures and solutions that are highly available and meet disaster recovery requirements
• Ability to identify gaps and risks with database strategy and security
• Effective capacity planning that can scale
• Database software lifecycle management (Patches and Upgrades)
• Design automated deployment procedures for on-premises and cloud
• Ensure successful delivery of solutions, training, and documentation, internally and with customers
• High-Availability design and builds using technologies SQL Server Failover Clusters
• Database, system, and application performance tuning
• Replication and Cloning Design and Solutions
• Backup recovery plans and execution
EXPERIENCE REQUIREMENTS
SQL Server DBA that has the following skill sets:
A minimum of 5 years database administration and design experiences with the following is required:
• Demonstrated experience in architecture of enterprise level database solutions
• Demonstrated experience with presentations in front of customers and management
• Excellent multitasking skills and task management strategies
• Ability to complete milestones and work toward multiple deadlines simultaneously
Advizex
• Ability to compile and organize statistical information and present findings to management
• Experience with cloud services (e.g., AWS, Azure, HPE Greenlake) is a plus
• Experience with SQL migrations on-prem and cloud
• Provide 24x7 support
• Participate in an on-call rotation
• Monitor system's health and performance
• Performance troubleshooting and resolution
• Analyze, solve, and correct issues in real time
• Handling daily issues (Blocking, long running Transactions, Deadlocks, etc.)
• Troubleshoot issues related to TempDb, Transaction log and System databases
• Knowledge of SSIS, SSRS (Definite Plus)
• Experience with backups, restores and recovery
• Scheduling database backups, taking full and Transaction log backups.
• Automate SQL server tasks (SQL jobs, Windows scripts, etc.)
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Excellent written and verbal communication
• Flexible, team player, "get-it-done” personality
• Ability to work in a rapidly changing environment
Experience identified below are additional positives:
• Familiarity with Oracle
• Familiarity with Open Source (e.g., MySQL, PostgreSQL)
• Supporting multi-site environment
• Experience with virtualization technologies
• Experience with Nagios, and scripting associated with plugin development
• Experience with using ServiceNow
• Experience with Logic Monitor
• Previous MSP experience
Source : Central Point Partners
