Troubleshoot data and query errors as reported by team members
Ability to develop database schema's and write clean SQL queries and code under tight deadlines
Query optimization and index tuning
Design and document database architecture
Evaluate and recommend new database technologies
Implement and maintain solutions to monitor database systems
Supporting high availability database (24/7/365 operation)
Self-organized with good time management, and ability to multitask
Setup and maintain working DR locations, with near real-time data synchronization
Strong understanding of HA environments including advanced techniques such as sharding, partitioning, and master/slave setups
Assist with Master Data Management solution
Required Skills and Experience:
5+ years experience with MSSQL, (MySQL and/or Postgres experience a plus)
Experience with system administration and architecture
Knowledge of database design standards
Experience in Windows and Linux operating systems preferred
5+yrs experience stored procedure programming
Strong troubleshooting skills
Ability to work independently and in a team environment
Proficient in both written and conversational English
Ability to work in a dynamic fast paced environment with multiple priorities and projects
Must work well with others. Collaboration and professional communication is key
Requires initiative to work when necessary to meet deadlines or when working on high-priority projects
Knowledge of SQL Server tooLog Outls ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
Strong knowledge of indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention issues.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, clustering, database mirroring, replication.