Senior DBA

Experience

Experience:
10+ years of database development and administration experience with RDBMS: SQL Server 2005 - 2019, Teradata 12 - 16, PostgreSQL 10, Oracle 11g

1. Database development and design:
- Database schema design
- Reviewing code as Global DBA team member
- Developing Stored procedures, Functions, Views, Triggers, Types, etc.
- Implementing Dynamic SQL
- Indexing, Performance tunning and optimization
- Partitioning and archiving, building Columnstore Indexes, etc.
- Developing OLTP, In-Memory OLTP
- DWH and Data vault development, Schema design, Normalization, OLAP, SSAS.
- T-SQL, ANSI SQL, PL/pgSQL, PL/SQL
- IDE: Visual Studio 2015-2017, Git, Jira
2. Database administration:
- Monitoring Azure and AWS database instances
- Backuping, Restoration, Replication
- Developing HA, Always-On
- Monitoring: SolarWinds, Sql Server Profiler, DMVs.
- Automation: Job Agent, Scripts
3. ETL:
- Developing SSIS packages
- Staging data loads as part of DWH ELT procedure, data cleancing, parsing JSON and XML, etc.

Skills

Microsoft SQL Server MS SQL Server MSSQL SQL T-SQL Teradata JSON NoSQL PostgreSQL OLTP OLAP DWH Business Intelligence SSIS SSAS ETL Git Azure Jira DB tuning and optimization

Highlights

Expert in SQL Server database
Need to take one look to know what can be improved.
Focused on query optimization and database performance troubleshooting
I have experience in globally distributed teams.
I keep good balance of planning and executing.

Looking for

Expected Position:
Senior DBA, Senior SQL Developer
- SQL Server
- Full-time
- Remote Job