Technical Skills:

· 10+ years of experience on Database Management Systems, configures database parameters and prototype designs against logical data models.

· Defines data repository requirements, data dictionaries and warehousing requirements.

· To optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.

· Experience/knowledge with Microsoft SQL Replication and CDC technology is must.

· Experience setting up and configuring HA (High Availability) / Replication/AlwaysOn. Preferably having researched and fine-tuned a setup so that the person understands what/why and can understand our needs and design/implement/configure a setup that meets client needs.

· Solid SQL Server DBA experience, in general.

· *The typical DBA skills / experience including DB maintenance, table/index/etc. maintenance, backups, monitoring, security, data dictionary, integrity checks, configuration, patching, and statistics, etc.

· Experience with SQL Server 2008/2012/2014/2016, preferably with multiple editions (Standard, Enterprise, etc.).

· Experience having installed and configured SQL Server instances in a similar capacity

· Thorough understanding of Performance Tuning – both as a System DBA and Application DBA (difference being Application DBA is more about query/application performance tuning and System DBA is about tuning the database itself, how it is configured, etc.).

· Strong SQL skills

· Strong Data Modeling skills both Logical/Physical Database Modeling knowledge

· Strong analytical and problem solving skills

· Excellent verbal and written communication skills

· Strong experienced with Microsoft tools and software (Visual Studio 2012/2015, SQL Mgmt. Studio, Microsoft Office, etc.)

· Experience with Data Warehousing and OLTP database management.

· Measure, track and meet SLA metrics (analytics cycle time, schedule, accuracy, rework, etc.).

· Assist in database performance tuning and troubleshooting database issues in both OLTP and EDW environments.

· Install, configure, and maintain critical SQL Server databases.

· Dimensional and relational based databases.

· Supporting internal and customer facing applications

· Assist in the full range of SQL Server maintenance activities (for example):

· Backups, restores, recovery models, database shrink operations, DBCC commands, and Replication.

· Table, Index, etc. design, creation, and maintenance.

· On-going maintenance activities - working to plan and automate as much as possible.

· Increase availability and performance while at the same time reducing manual support time.

· Assist as part of the team designing, building, and maintaining the future state of Merchants database platforms:

· SQL Server versions, editions, and components.

· Database server configuration.

· Database and Data Model standards

· Business Continuity and High Availability strategy.

· Overall Data Architecture.

· Upgrade and Patching strategy.

· Knowledge in snowflakes, stored procedures is preferred.

· Knowledge in ETL Integration layer ,SSIS and SSRS.

· Installation and configuration of SSRS, SSIS and SSAS.

Good to have

· Deep Azure experience

Process Skills:

· General SDLC processes

· Understanding of utilizing Agile and Scrum software development methodologies

· Skill in gathering and documenting user requirements and writing technical specifications

Behavioral Skills :

· Good Attitude and Quick learner

· Well-developed analytical & problem-solving skills

· Strong oral and written communication skills

· Excellent team player, able to work with virtual teams

· Excellent leadership skills with ability lead and guide and groom the team

· Self-motivated and capable of working independently with minimal management supervision

· Able to talk to client directly and report