Career Evolutions is searching for an experienced Sr. SQL Database Administrator (DBA) for a premier private university in Phoenix AZ. This full-time position will be in IT Shared Services department with salary >100K and a great benefit package available. The working schedule will be Monday through Friday, 8 a.m. to 5 p.m. with occasional weekends and afterhours as needed.
This position will be responsible for database engineering, as well as support/develop SQL Server databases and work with Infrastructure DBA to ensure the performance, availability, and security of the databases.
The ideal candidate should have a proven track record of successfully delivering and maintaining Database Management, MSSQL Server, SQL Programming, Database Security, Requirements Analysis, Problem Solving, Promoting Process Improvement, Data Maintenance, Database Performance Tuning, Process Improvement, Large System Implementation, Database replication, and Good understanding of Windows OS administration.
Responsibilities (MS SQL Server):
Extensive knowledge with SQL Database Replication Implementation Knowledge on SQL Mirroring and log shipping Exceptional knowledge of SQL Monitoring tool IDERA Workable knowledge of Storage and Hardware and Network components used in DB clustering Good Performance tuning and trouble shooting skills are mandatory T-SQL coding and PowerShell coding is a must Extensive work experience with Snapshots using NetApp storage technologies Good customer service attitude and willing to go on-call and assist the team as needed are mandatory Knowledge with SQL 2012 Always On to implement HA and DR solutions Responsible for database scripting, setting the configuration of both and SQL Server Having working experience with both and MS SQL Server databases install Responsible for troubleshooting and problem solving of SQL development Assist infrastructure DBA with routine performance and availability testing on database servers to ensure scalability, resiliency, and capacity of all applications Provides expert level database administration support to 3rd party vendors, developers and others as needed Optimizes SQL performance, partitioning, indexing, stored procedures and DTS packages Establishes monitoring thresholds for database systems Works evenings and weekends, as required, providing support and maintenance for systems, providing 24/7 support and troubleshooting for business critical database servers Establishes physical database parameters, including, file system layout and performance requirements Manages patch deployment and migration for SQL Server, including, testing procedures and release/change management processes Works closely with System Administrators & Application Development teams to support the architecture/operational practices Assists in developing and testing disaster recovery procedures and plans for Microsoft SQL applications Interfaces with application providers to assist in optimizing third party applications Manages capacity planning activity for database systems including storage usage Provides and manages data replication services as needed Provides support for applications with database troubleshooting Executing database backup and recovery operations, database patching and upgrades, and implementation of database security policies Maintaining and enhancing database maintenance routines Partnering with project technical leads and development teams to execute technical solutions in line with customer expectations and company strategic goals Integrating SQL systems with third-party tools and environments Responsible for database engineering, as well as build, run, and help provide strategic technical direction for the department. Supports and develops SQL Server databases. Work with the infrastructure DBA to ensure the performance, availability, and security of the databases. Performs other related duties as assigned
Minimum 9 years of related experience with at least 5 of those years using SQL Server in a DBA/equivalent role DBA experience supporting of large enterprise-wide high availability databases and data warehouses In depth SQL Server Database Administration experience including clustering Experience managing multiple MS SQL 2000/2005/2008 RDBMS on large systems. Having BI/ Data warehousing experience on Microsoft tools is a huge asset as well. Strong self-sufficiency and initiative working on Database projects Practical experience in monitoring and tuning a database to provide a high availability service Experience with Transactional SQL (T-SQL) and SSIS Packages Practical experience in managing the internal and external and MS SQL database security, maintenance plans, and disaster recovery
BI/ Data warehousing experience on Microsoft tools is a huge asset My SQL (5.1.X 5.5.X ) and MS SQL (2005, 2008 / T-SQL / SSIS / SSRS / SSAS ) experience Experience managing multiple MS SQL 2000/2005/2008 RDBMS on large systems Oracle experience
Medical, dental, vision, life and disability insurance, flexible spending accounts, 401K savings plan, Education Tuition Program of up to 100% of tuition costs and a generous holiday and paid time off package
Career Evolutions focuses on understanding your business and its needs, as we're always interested in long-term professional relationships....