We provide IT Staff Augmentation Services!

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

Hire Now