We provide IT Staff Augmentation Services!

Sql Server Dba And Data Warehouse Consultant Responsibilities: Resume

SUMMARY

  • Over 7 years of experience Microsoft, Oracle and SAP environment in Dev & Prod as a Developer and Administrator.
  • Experienced with SQL Servers 2008/2008R2/2012/2014 and 2016, SSIS, SSRS, SSIS, Tableau, Oracle Business intelligence, Oracle Weblogic, SAP BODS, HANA and Splunk.
  • Offers solid track record based on professionalism, thoroughness, and dedication.
  • Able to work independently and as a team player with outstanding performance.
  • Excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS

Languages: T - SQL, PL/SQL, SQL CLR, C#, C++, Python, .NET, Java, ABAP HTML, CSS and XML

ETL And reporting Tools: Microsoft SSIS, SSAS, Tableau, SSRS and OBIEE, SAP BODS.

RDBMS & Tools: SQL Server 2005/2008/2008 r2/2012/2014/ and 2016, MS Access 2003/2007/2010/2013/2016 , SQL Loader

Operating System: Windows NT/ 2000/2003/2008/2008 r2/Windows server 2012 & Windows Server 2012R2, RHEL 6, CentOS 6&7, Ubuntu.

Database Query Tools: SQL Profiler, SSMS, Visual Studio Idera, Redgate and Enterprise Manager.

Virtualization Tools: VMware work station, VMware hypervisor ESXI 5.5

Cloud Technology: AWS and Azure

Log analyzing tool: Splunk

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA and Data warehouse Consultant

Responsibilities:

  • Managed and support Confidential ’s Rotary Mission System’s (RMS) Business Intelligence (BI) data warehouse
  • Tracked and managed performance improvement opportunities to prioritize efforts across the support, Production and Development environment
  • Directly responsible for over 100 SQL Databases in an environment with 500+ SQL Databases
  • Management of databases ranging in size of up to 8.2TBs and partitioning index / table for subdivision into smaller pieces.
  • Migrated data from production to development and vice versa using export/import utilities, SAP BODS Management console.
  • Created Data Services job using SAP Business Object Data Service designer (BODS).
  • Monitored Data service jobs in Tidal, SQL agent jobs in Dev & Prod environment and reported job performance to Team Manager.
  • Updated and modify SQL and Oracle script according to user requirement.
  • Provided users support by solving incident ticket which originated from SAP, Oracle, MS SQL, Tableau, MS Access, SSIS and SSRS.
  • Solved data missing issues, unique constraint violations, SSL certificate issues, file connection etc. on SQL, Oracle and SAP environment.
  • Experienced in Data provisioning using SLT replications, Business Object Data Service (BODS) and Microsoft Business Intelligence (MSBI).
  • Set up connection in between different types of databases (Oracle, SQL) and applications(Tableau, Microsoft Access) by modifying TNS.ora file and creating drivers
  • Setup Row Level Security (RLS) to prevent unauthorized access.
  • Monitored Server logs using Splunk and prepares report as necessary.
  • Experienced in securing the SQL Servers and assign the permissions to SQL Server users and deployed Transparent Database Encryption (TDE)
  • Created users and setup different level of security for users.
  • Experienced with SQL Server performance using windows performance monitor, Activity monitor, PerfMon and other SQL native tools.
  • Experienced with improving the database performance using execution plan, index tuning wizards and SQL profilers.
  • Worked with the SQL Developers to change the stored procedures script to improve the performance.
  • Created and deployed policy in SQL Server using Policy Base Management (PBM)
  • Migrated data on-premises to Amazon Simple Storage System(S3)
  • Created and managed AWS bucket, and transferred to AWS Glacier and setup retention polices
  • Provided 24x7 dedicated production support for SQL Server in Dev and Prod.

Confidential

SQL Server DBA/Developer

Responsibilities:

  • Extensive experienced in MS SQL Server 2016/2014/2012 Business Intelligence in MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS) and using Server Analysis Service (SSAS) .
  • Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to create SSIS Packages and deployed packages to Development, QA and production server using SSMS.
  • Created SSIS packages which involved a variety of transformations such as, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, Row count, Sort, Data Conversion etc. before loading the data into Data Warehouse.
  • Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in data warehouse.
  • Experienced in Performance Tuning and Query Optimization performance
  • Worked with T-SQL in constructing Triggers, Tables, Implementing Stored Procedures, functions, Views and Data Integrity
  • Experienced in designing, creating, processing of cubes using SSAS.
  • Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
  • Used SSRS to create, execute, and deliver tabular, matrix, and charts reports
  • Supported performance related issues in production database and optimized stored procedures/queries with the help of different Microsoft tools.
  • Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
  • Developed OLAP Cube by using Server Analysis Service (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Calculations using multi-dimensional expression (MDX), Perspective and Roles.
  • Perform database migration in 2008R2, 2012 SQL server environment.
  • Secured SQL Server via Managing Logins, users and object level permissions.
  • Monitored and administered Replication, database Mirroring & Log Shipping
  • Performed Snapshot, Transactional, Merge replication and in SQL server and monitor replication activities.
  • Performed Full, Differential, Transactional, Partial, copy only database backup and restores for multiple development and production server.
  • Configured and Optimizing SQL Server Agent, Managing all maintenance Jobs and scheduling different alerts.
  • Applied Service packs and hot fixes on all production/dev/test/training Sql instances on every month.
  • Worked with windows admin, Storage group, data centre engineers & network administrators
  • Created and solved tickets using Service Now ticketing system.

Confidential, NYC

SQL Server DBA

Responsibilities:

  • Installed and configured SQL 2014 and 2016 in Production and non-production Environment.
  • Setup backup and restore production databases in test and development servers using SQL server native tools and Redgate SQL backup.
  • Configured and monitored Snapshot Replication, Transactional replication and Merge replication
  • Implemented Log shipping and mirroring as a part of HA and DR
  • Performed Snapshot, Transactional, Merge replication and in SQL server and monitor replication activities
  • Performed Full, Differential, Transactional, Partial, copy only database backup and restores for multiple development and production server.
  • Worked on Always ON Environment and configured Always on in SQL 2012 version with 4 replicas which included 1 primary replica and 3 secondary replicas and documented process
  • Configured Domain Controller (DC), IP address, Shared fodders, Automatic and manual fail over, Always-On availability group (AOAG) on Dev and Prod environment.
  • Installed and configured the MS SQL Fail over clustering for production servers.
  • Configured Heartbeat connection, Public network connection and shared storage drive in Cluster environment
  • Troubleshoot issues with Availability Groups/Replicas/Databases/Listener
  • Experienced with setting up the backup strategy for production, test and development
  • Involved in upgrade SQL Server 2012, 2014 to SQL server 2016.
  • Responsible for 200+ database migration from SQL server to SQL Azure using Microsoft DMA and SSMS.
  • Setup and maintain Azure database security and configure firewall.
  • Maintain both Azure SQL Database and SQL server on Azure Virtual Machines(VMs)
  • Deploy applications to Azure using Microsoft web services and maintain applications.
  • Experienced with improving SQL Server performance using windows performance monitor, Activity monitor.
  • Experienced with improving the database performance using execution plan, index tuning wizards and SQL profilers.
  • Worked with the SQL Developers to change the stored procedures codes to improve the performance.
  • Experienced on Power Shell scripts

Confidential, Louisville, KY

Data Analyst & Report developer

Responsibilities:

  • Analyzed and modified SSIS ETL packages for changed business requirements to load data from different internal department sources to SQL Server tables in data warehouse.
  • Extensive experience in MS SQL Server 2016/2014/2012/2008 R2 Business Intelligence in MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS).
  • Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to create SSIS Packages and deployed packages to Development, QA and production server using SSMS.
  • Created SSIS packages which involved a variety of transformations such as, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, Row count, Sort, Data Conversion etc. before loading the data into Data Warehouse.
  • Experienced in designing, creating, processing of cubes using SSAS.
  • Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
  • Used SSRS and Excel to create, execute, and deliver tabular, matrix, and charts reports
  • Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
  • Developed OLAP Cube by using Server Analysis Service (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Calculations using multi-dimensional expression (MDX), Perspective and Roles.
  • Supported performance related issues in production database and optimized stored procedures/queries with the help of different Microsoft tools.
  • Performed Snapshot, Transactional, Merge replication and in SQL server and monitor replication activities.
  • Prepared Daily, Weekly and monthly report using confidential data and distributed the reports different internal departments
  • Responsible for a large scale of database migration from SQL server to Amazon RDS.
  • Experienced in AWS Cloud, creating EC2 instance and setup security
  • Maintained database in both Amazon RDS and Amazon EC2 instances
  • Analysed and queried big amount of data in Amazon Redshift and created view
  • Configured Amazon S3, and S3 Glacier for archive data and created bucket policies
  • Extensive knowledge Amazon Data Lake, RA3, Federate queries and other AWS technologies
  • Configured and Optimized SQL Server Agent, Managing all maintenance Jobs and scheduling different alerts.

Hire Now