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