SQL DBA Resume

SUMMARY:

13+years of experience(Onsite/Offshore) with Microsoft Certified Professional (MCP) in Microsoft Technologies.
Worked more than a year in United Kingdom on client location for development and implementations.
Big achievement on Process optimization on complex project from 21 hours to 30 Minutes.
Excellent back end skills in creating SQL objects such as Tables, Stored Procedures, Views, Indexes, Triggers, defaults, Optimization, SQL Profiler and user defined data types and Functions
Hands - on experience in SSRS, SSIS package/ DTS creation and deployment, and maintaining, modifying, and optimizing MS SQL Server databases
Worked as SQL DBA as well for 2 years in Production support.
Hands experience on Power BI with DAX and Data analytics with various sources
Certified on Power BI with DAX(70-778)
Hands on experience on Business Analysis, Database Design, Development and Implementation.
Hands-on experience in data modeling (logical and physical design of databases), normalization, and building referential integrity constraints.
Having good experience in agile work model along with JIRA, Cherwell and Version One system.

TECHNICAL SKILLS:

Databases: MS SQL Server 2000/ 2005/2008/2008 R2/2012/2016, Oracle 11g, HP Neoview

Languages: C++, C#, .NET, Visual Basic 6.0, HTML, XML

Internet Technologies: ASP.NET, ADO.NET, HTML

Operating Systems: Windows 2007 Pro/ 2000 Advanced Server/ XP/ windows 10

Front-end Technologies: MS Visual Studio.NET 2003, MS Visual Basic 6.0

Tools: DTS, SSIS, SSRS, Power BI,DAX, Crystal Report, QlikView,Cherwell

PROJECT EXPERIENCE:

Confidential

SQL DBA

Responsibilities:

Worked on report migration from SSRS and Cognos to Power BI.
Writing SQL development coding and deliver end to project. I.e. stored proc, Function, Tables, Views etc.
Contributed towards technical and functional documentation, implementation, application support, and client interaction
Working on Complete solution on from design to implementation.

Confidential

SQL DBA

Responsibilities:

Understanding the Business requirements, worked on MS SQL Server 2008 R2, Design Report designing.
Replication setup, Unit Testing Creation of database objects like tables, stored procedures and Deployments along with New Changes Request Planning and developments.

Confidential

SQL DBA

Responsibilities:

Engaged in team handling, performance and process optimization, database support, and programming
Contributed towards technical and functional documentation, implementation, application support, and client interaction
Engaged in severity work assignment and database migration (SSIS/ DTS)

Environment: MS SQL Server 2008 R2, Dot NET, DB2, Oracle

Confidential

SQL DBA

Responsibilities:

Engaged in database Programming, SSIS/ DTS development, and support
Involved in database migration from existing database to new database (MSBI), client interaction, and SSRS

Environment: MS SQL Server, DB2, Java

Confidential

SQL DBA

Responsibilities:

Engaged in DTS/ SSIS package, database programming, process design, and various job creations
Contributed towards data extraction from legacy system, SSRS generation, and loading XML wrapper

Environment: MS SQL Server 2005, XML

Confidential

Production support

Responsibilities:

Designed database, and defined business logic
Engaged in log shipping, and created/ maintained jobs, and optimized SQL
Wrote complex queries, functions, views, and triggers

Environment: Visual Studio.NET, MS SQL Server 2005

Confidential

Production support

Responsibilities:

Maintained and upgraded database, partition tables, and replication (snapshot and transactional/ merge)
Engaged in coding for various stored procedure, triggers, and views and performance tuning for reports
Engaged in various daily jobs activities and deployment of production releases
Involved in backup/ restore of database, database migration, SSIS package with DTS, and supporting of job monitoring

Environment: Visual Studio.NET, MS SQL Server 2005

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship