SQL Server DBA
WHO ARE YOU?
As a SQL Server DBA you have experience overseeing the technical design, planning, implementation, performance tuning, support and recovery procedures for all corporate, private and public cloud systems, with emphasis on MS SQL and AWS. You will be one of our technical experts with the administration of complex systems and services and deliver world-class solutions to Procare’s internal and external customers. Additionally, you will contribute to architectural design of our AWS environments, ensuring scalability, stability, operational efficiency, and sustainability.
To succeed in the role, you must be passionate and energetic to ensure our customers continuously experience top-notch performance while utilizing highly available, secure products.
WHAT YOU OFFER
Our ideal candidates will have experience with:
- Administering, troubleshooting, resolving problems, monitoring, and conducting performance management and reporting. Designing, administration and monitoring of all database systems.
- Supporting DevOps initiatives including, but not limited to, building pipeline support, testing environment containerization support and site reliability knowledge.
- Continually improving and being proactive to ensure effectiveness and efficiency of system performance using qualitative and quantitative measures.
- Detecting, isolating, and resolving system issues encountered during operations. Additionally, providing documentation, new standards or procedures and communication on any lessons learned post incident.
- Sharing knowledge and best practices with the Operations Team.
- Participating in after-hours call coverage shared by team.
- Building and maintaining strong working relationships across all stakeholder groups. Advise, influence, and support all teams to achieve goals.
- Supporting the implementation, testing and documentation of Disaster Recovery/Business Continuity initiatives.
- Working within the established and documented process for change management to build, test and implement approved changes.
- Experience architecting and designing complex infrastructures.
- Expert knowledge of Microsoft SQL and PowerShell
- Working knowledge of MySQL, Postgres, Amazon Web Services (AWS) RDS, Active Directory, load balancing, HA/DR and DNS.
- Experience with AWS cloud platform technologies such as API Gateway, Lambda, RDS, DynamoDB, SQS, SES, S3, Cognito, Cloud Front, Cloud Watch, etc
- Ability to provide appropriate, relevant written guidance to stakeholder groups ranging from developers to executives
- Working knowledge of and experience with Agile and ITIL
- Must have the ability to multi-task in a very dynamic environment with changing priorities.
- Confidence to drive accountability for deadlines across departments and organization structures
- Ability to commit time and energy required to meet project schedules and objectives
- An attention to detail, and ability to clearly articulate the status of multiple efforts at any time
- Ability to problem solve and adjust as challenges arise or risks are uncovered
SKILLS & ABILITIES:
DESIRED QUALIFICATIONS:
- 8+ years of IT experience as Database Administrator
- Strong understanding on installation, configuration, patching, supporting, and upgrading Microsoft SQL on Windows Machine
- Strong knowledge of MySQL Queries, Stored procedures, and functions
- Strong Database Design, performance tuning skills
- Strong knowledge of PowerShell
- 1+ years experience on AWS cloud, deploying and managing AWS RDS MySQL, PostgreSQL, and MS SQL databases.
- Designs, documents, implements, and monitors backup of database and other database protection or high availability solutions such as replication, synchronization, clustering
- Familiar with replication and clustering technologies for MS SQL database clusters in Hyper-V environment
- Familiar with 3rd party monitoring solutions like SolarWinds DPA and PRTG
- Experience in enforcing standards for user account, group, and database security and configuration for all production databases and for nonproduction databases
- Experience with heterogenous and/or homogenous migration of database: MS SQL to AWS etc.
- Ability to take full ownership of availability and security of production data
- Good exposure to at least one scripting language: shell scripts, python, perl
- Have written moderately complex PowerShell scripts
- Strong Communication skills (verbal and written) with an ability to work in a highly collaborative, multi-time zone environment
- Good organizational skills with the ability to track and prioritize numerous tasks
- Participate in 24x7x365 rotation as needed, to ensure availability of environments. Monitor performance to ensure that requirements are met.