This is a contract to hire position with a client located in Meridian, ID. The initial contract term is 6 months.
***All candidates must be local to the Boise area. The role will be a mix of on-site and remote work.
Summary:
This role supports our vision by installing, analyzing, maintaining, and troubleshooting Microsoft SQL instances and database operations across the enterprise in order to maintain secure, stable, and available SQL communications for end users, internal customers, and public facing services.
Required Knowledge, Skills, and Abilities:
Extensive experience installing and administering Microsoft SQL Server 2005 through 2016 in both physical and virtual environments Extensive experience developing T-SQL scripts in order to manipulating database objects Extensive experience with database planning, design, configuration, maintenance, and performance tuning Extensive Experience implementing database replication, database mirroring, and log shipping Extensive Experience implementing SQL failover clustering, and always-on availability groups Extensive Experience implementing SQL backup methodologies, and disaster recovery Working knowledge of table partitioning and SSIS package development for BI integration Working Knowledge of maintenance and monitoring tools for both Windows servers and SQL instances Working knowledge of Microsoft Best Practices for SQL Server Configuration. Demonstrated skills in technical documentation Demonstrated analytical, deductive reasoning and troubleshooting skills Demonstrated organization skills Demonstrated customer service skills Ability to interact with personnel on all levels of the organization Ability to work independently or as a member of the team Ability to communicate orally and in writing Ability to set priorities, meet deadlines and multi-task with minimal supervision Ability to be detailed-oriented Ability to research future hardware/software technologies Essential Job Functions:
On-demand installation and configuration of SQL server instances using best practices Analysis of all SQL instances and databases for performance tuning and optimization Administration of all SQL database backups, maintenance schedules, and other data protection services Administration of policies, standards, procedures and guidelines necessary to effectively maintain the database environment Design and implement high availability SQL solutions using log shipping, database mirroring, replication, and always-on availability groups and SQL Failover clustering Regular review of business requirements to develop and mature the enterprise data architecture strategy Partner with IT teams to provide design recommendations based on long-term strategic goals Document and maintain database system specifications, diagrams and connectivity charts Leverage Change Control processes for all SQL Server changes made in the Production environment Valuable Additional Experience:
Working knowledge SQL Sentry Working knowledge SQL server administration in the Azure Platform Minimum Required Education, Training and Experience:
1-3 years performing Microsoft SQL server management in a medium size business network-environment with either: Current MS SQL Certification(s) Or
College degree in related technical field Or
Equivalent work experience