Must be familiar with database design concepts, methods for creating highly available environments, industry standards for security and integrity, options for integrating onsite and hosted data sources, tools for monitoring and tuning database instances, and programming techniques for writing efficient queries.
Must be able to effectively establish and document requirements, track and report on projects, publish technical documentation of solutions, and research and understand best practices and regulatory obligations.
The right candidate will ideally have past hands-on experience administering MS SQL databases running in a public cloud environment such as AWS or MS Azure.
Assess the health of databases, articulate issues, and formulate resolutions
Design, build, analyze, tune, back up, and support databases
Understand and able to troubleshoot and maintain database servers
Take proactive measures to monitor, trend, and tune SQL databases, such as running maintenance jobs (backups, DBCCs, applying indexes/re-indexing, etc.), to meet or exceed baseline stability and performance SLAs
Develop and maintain SQL stored procedures, views, functions, ETL programs, and ad-hoc queries to support business needs
Develop, schedule, and monitor SSIS packages
Integrate data from various back-end databases and data sources
Manage and audit user access to DEV/TEST and PROD databases
Analyze business system requirements and design appropriate technical solutions
Develop system documentation as needed, including technical and user documentation
Bachelor's Degree in information technology or a related field or equivalent work experience
3+ years' experience administering and maintaining replicated Microsoft SQL Server databases in a distributed production environment
1+ years of Azure administration will be a huge plus.
Expert proficiency with Microsoft environment and tools, such as Enterprise Manager, Query Analyzer, and Profiler
Development experience with SSRS, SSIS, and automating SQL Server deployment and configuration through PowerShell, Chef, etc.
Experience with PowerShell scripting
Proficiency with query optimization, SQL development, parameterized queries, and T-SQL for developing complex stored procedures, triggers, etc.
At Consulting Professional Resources (CPR), we provide staffing and placement services in the information technology industry for corporations that require skilled personnel for managing and executing projects. We experience rapid growth and continue to expand in the IT market.
Our goal is to provide a more profitable connection between information technology services and the companies that ut...ilize them. We focus on providing measurable results and are fully committed to the success of our clients and employees alike. We stand behind our commitment with a performance guarantee to do whatever is necessary to meet this goal.
Continuous improvement is the standard that we apply to everything from employee compensation to customer satisfaction. Pursuing this philosophy, we have built a strong reputation for quality and professionalism, becoming the long-term IT solution for many premier clients.