Sr SQL DBA -
This job is no longer active.
View similar jobs.
POST DATE 9/12/2016
END DATE 10/24/2016
JOB DESCRIPTIONWe are seeking a Senior SQL DBA to focus on developing and managing database technologies and/or assigned software specialty. This is a full-time direct-hire position in Central Phoenix. Salary up to $100K plus a generous benefits package.
? Provides expert level database administration support to third-party vendors, developers and others as needed.
? Maintains high availability databases in support of 24/7 services.
? Optimizes SQL performance, partitioning, indexing, stored procedures and DTS packages.
? Database scripting and setting the configuration of both and SQL server.
? Manages patch deployment and migration for SQL servers, including testing procedures and release/change management processes.
? Establishes physical database parameters including file system layout and performance requirements.
? Works closely with Systems Administrators and Application Development teams to support architecture/operational practices.
? Assists infrastructure database administrators with routine performance and availability testing on database servers to ensure scalability, resiliency and capacity of all applications and to ensure the performance, availability and security of the databases.
? Manages capacity planning activity for database systems including storage usage.
? Integrates SQL systems with third-party tools and environments.
? Establishes monitoring thresholds for database systems.
? Provides and manages data replication services as needed.
? Assists in developing and testing disaster recovery procedures and plans for MS SQL applications.
? Executes database backup and recovery operations, database patching and upgrades and implementation of database security policies.
? 5 years of full-time MS SQL database administration in a high-availability production environment preferred; experience in higher education with online services preferred, including:
? Extensive knowledge with Snapshots using NetApp storage technologies
? BI/Data warehousing experience on Microsoft tools is helpful.
? Experience with Transactional SQL (T-SQL) and SSIS Packages.
? Practical experience in managing internal and external and MS SQL database security, maintenance plans and disaster recovery.
? Extensive and advanced knowledge of SQL databases and replica-sets gained through running critical systems.
? Thorough understanding of Profiling, Performance Tuning and Optimization, using native monitoring and troubleshooting tools to resolve database problems.
? In-depth knowledge of SQL Server Database Administration including clustering.
? Strong proficiency of T-SQL coding, PowerShell coding and stored procedures.
? Exceptional knowledge of SQL Monitoring tool ? IDERA.
? Implementation knowledge and ability with SQL Mirroring and log shipping.
? Knowledge of indexes, index management and statistics.
? Knowledge of MS SQL 2000/2005/2008 RDBMS on large systems helpful.
? Extensive knowledge of Snapshots using NetApp storage technologies.
? Knowledge of SQL 2012 ? Always On to implement High Availability and Disaster Recovery solutions.
? Willingness to work evenings, weekends, holidays as required to provide support and maintenance for systems, and to ensure 24/7 support and troubleshooting of business-critical database servers. Will to work ?on call? regularly.
We are an equal employment opportunity employer and will consider all qualified candidates without regard to disability or protected veteran status.
Must be able to pass background check