SQL Dba Data Modeller

**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
- 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.
- 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 mínimal management supervision
- Able to talk to client directly and report