Senior SQL Server Database Administrator SpringCM
THIS JOB HAS EXPIRED At SpringCM, we are passionate about cutting edge technology that delivers industry-leading enterprise cloud solutions. Our team of super smart engineers with focus on cloud computing is tackling the world's most challenging tasks building highly scalable and available products. We have great plans for the future and looking for the smartest and most driven people out there to help us. We are seeking versatile, talented engineers to help us build the next generation of content management cloud solutions.
SpringCM is looking for a Senior SQL Server Database Administrator to assist in successful operations of the SpringCM platform. The ideal candidate is highly experienced in Microsoft technologies, custom developed .NET applications, N-tier design, and Service-Oriented Architectures.
The Database Administrator reports to the Vice President of Infrastructure and DevOps and is expected to participate with other engineers in the Infrastructure and DevOps teams, as well as with R&D and QA teams, in order to optimize the performance, scalability, and availability of the rapidly growing SpringCM platform and its supporting infrastructure.
Required Skills for the Senior SQL Server Database Administrator include the following technical qualifications:
2 years of advanced knowledge of database design for large databases across multiple clusters
2 years of advanced knowledge of database development and administration
2 years of experience with data replication environments across multiple geographic data centers
2 years of experience with SAN provided database storage environments
2 years of experience in a High Availability production environment
Ensure all databases are available and up and running
Ensure network connectivity to the servers
Check Event Viewer for error messages
Check for adequate disk space for growing database files and log files
Check the SQL Server logs for failures
Backup the SQL Server transaction log
Perform full and differential database backups as required
Monitor Windows 2008 and SQL Server counters in System Monitor to ensure optimal performance
Track locking, blocking, deadlocks, long running queries and high-resource queries
Track in System Monitor, processor, memory, disk I/O and network activity.
Use data collection tools and software to generate performance reports
Use Resource Governor to limit the amount of resources allocated to specific applications.
Resolve all trouble tickets and document the process.
Helps maintain the index strategy.
Creates and maintains a file group and locking strategy.
Implement and maintain log shipping.
Implement and maintain snapshot and transactional replication
Implement and maintain NetApp SnapManager for SQL.
Perform DBCC CHECKDB on all restored and production databases.
Compare gathered performance statistics with baseline statistics to improve performance and to forecast future hardware/software acquisitions.
Use parallelism, lock management, memory management, I/O analysis and diagnosis of on-going issues to improve overall database performance
Separates databases to accommodate splits to application processes
Perform recovery tests as required.
Provides primary support in incident, crisis and change management.
Implement and maintain an archiving and purging strategy
Implement and maintain a disaster recovery plan
Develop and maintain the partitioning strategy
Reviews estimated and actual execution plans for performance. Able to detect table scans, index scans, merge joins, rewinds, rebinds and hash matches within T-SQL code.
Makes recommendations for using plan hints and freeze plans to stabilize generating execution plans
Managing database users, security, and using roles to assign permissions to the various database objects such as tables, views, and stored procedures.
Work closely with development teams to assist in overall database design, helping developers tune queries, assigning proper indexes, and aiding developers in the creation of triggers and stored procedures.
Working with tools to perform tuning and tracing activities.
Experience with modeling, building, and managing warehousing activities.
Provides technical support in incident, crisis and change management.
Ability to participate in rotational production support of a 24x7 operation
Sound understanding of Server 2003/2008 Operating Systems, including MSCS/Failover Clusters
General understanding of network architectures
Understanding of .NET applications (ie. connection pooling, etc.)
Experience with SQL Servers running in virtual environments
Experience with web-based transaction processing within a Microsoft .NET environment, Web 2.0, SOA and Web Services
Strong understanding of the SQL Server engine, architecture, and internals
Strong understanding of T-SQL
Strong understanding of SQL Server security methods
Strong understanding of SQL Replication
Some familiarity with SQL Server 2008 encryption approaches and methods
Some familiarity with SSIS
Some familiarity with Analysis Services
Experience using monitoring softwares (Quest/Idera/SQL Server 2008 native tools) for the purposes of analyzing performance, availability, and capacity issues.
Some familiarity with SAN and storage planning
Some familiarity with participating in team load and stress testing exercises
||Chicago, IL |
THIS JOB HAS EXPIRED