Desired Skills and Experience
- Experience with Database Administration for MSSQL Server. Managing multiple MS SQL 2005, 2008, 2008R2 and/or 2012 instances.
- Experience with SQL Server Replication and SQL Server Integration/Reporting Services
- Experience with backups, restores and recovery models.
- Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Experience/knowledge of Log Shipping
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
- Knowledge of indexes, index management, and statistics.
- Experience in implementing operational automation using scripts.
- Experience working with Windows server, including Active Directory and proper disk configurations.
- Good communication and documentation skills.
- Experience handling and managing SQL databases in a real time production environment with sizes around 500+ GB
- 6 + years’ experience of SQL Server database administration within a high volume, transaction-oriented web environment
- Hands-on experience in relational database architecture, data modeling, database design, (logical, physical)
- Familiarity with data warehousing technologies and methodologies, BI/ETL tools and OLAP
- Familiarity with tools and software products for data model, schema development and master data management
- Thorough working knowledge of various business process and system modeling tools including: Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, Context Models, Event Modeling, State Modeling, Process decomposition, and Use Case Scenarios.
- Excellent organizational and workflow skills; ability to work on simultaneous projects with diverse working groups
- Self-motivated, responsible, and accountable
- Ability to work well independently and within a fast-paced, team-oriented environment
- Ability to follow standard processes and communicate effectively with the team regarding technical, progress and critical issues
- Ability to educate, communicate and present effectively with business and IT stakeholders to gain consensus on database initiatives