SUMMARY

• Around 9 years as Certified SQL SERVER DBA, Application DBA, Microsoft Certified MSBI Consultant and Report Developer, Certified SCRUM Master
• SQL SERVER DBA With Confidential supporting in migrating the Versions of SQL SERVER 2000, 2005, 2008/2008 R2, 2012, 2014 to SQL SERVER 2016.
• SQL SERVER DBA With Confidential supporting all the Dev, QA and Prod Environments with SQL SERVER Nightly job processing which is a combination of ETL and Reporting tool jobs
• SQL SERVER DBA with Confidential . Supporting 33 Servers of which 22 are Production Servers while rest are Non - Production Servers using wide variety of SQL SERVER and third party tools from IDERA like IDERA Diagnostic Manager and IDERA Admin Toolset.
• Good Understanding over Azure Data Lake and Azure Data Factory.
• Extensive experience in Extracting, Transforming and Loading (ETL) data into centralized databases from and to wide variety of data sources like Excel and Spreadsheets, Text files, SQL SERVER and Oracle using Integration Services and SP’s. Also good in validating and testing that the data pumped is valid.
• Experience in providing Logging, Error Handling by using Event Handlers and custom Logging for SSIS Packages.
• Sound knowledge in T-SQL Programming including SP’s, Indexed Views, and Triggers.
• Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues per standards.
• Good communication, presentation and documenting skills.
• Good in understanding new technologies in a fast and steady pace.
• Highly customer oriented.

TECHNICAL SKILLS

Databases: SQL SERVER 2000/2005/2008/2008 R2/2012/2014, InterSystems Cache

ETL Tools: SQL SERVER Integration Services (SSIS), Informatica 7.1.1, 8.6

Reporting Tools: SQL SERVER Reporting Services (SSRS), Cognos 8.X, Power BI, Tableau 8.1 (Limited knowledge)

Cloud: Azure Data Lake, Azure Data Factory, AWS (Amazon Web Services)

Programming Languages: C, C++, C#, T-SQL, R Language, Python and associated libraries

Third Party Tools: Power BI, Backup Utility, Excel PowerView, Pragmatic Works TaskFactory for SSIS, IDERA SQL Diagnostic Manager, IDERA Admin Toolset

Operating Systems: Desktop Editions: Windows XP, Windows 7, Windows 8, UBUNTU 14.0 (Debian Flavor)

PROFESSIONAL EXPERIENCE

SQL SERVER DBA

Confidential

Responsibilities:

• Worked as SQL SERVER DBA for a team of 4 for HarperCollins Publishing co
• Worked on migrating SQL SERVER 2000, 2005, 2008/2008R2, 2012, 2014 Versions to SQL SERVER 2016.
• Worked closely with different stakeholders to make sure all the tests are through.
• Worked on PowerBI for analytics.
• SCRUM Master for Industrial Badger App (IBA)

SQL SERVER DBA

Confidential

Responsibilities:

• Worked as DBA for a team of 6 for Honeywell Intelligrated systems.
• Mostly worked on Compliances.
• Worked on Server Monitoring Tool SolarWinds for Critical System Monitoring.
• Worked on NetApp for backup and restore operations.
• Worked on SQL SERVER Nightly Job processing’s which is a combination of ETL & Reporting jobs in both PowerShell and T-SQL statements

SQL SERVER DBA

Confidential

Responsibilities:

• DBA Team Lead for a team of 4 team members for Newpark Drilling Fluids (NDF), Houston, Texas, US.
• Installed, Configured, troubleshooting of Azure Compute instances, Azure Backup, Azure Storage Monitor, snapshot, Azure Storage
• Worked at L3 level on day to day operational issues, requests and project tasks involving various technologies e.g. Azure, Windows server, patching SQL SERVER.
• Responsible for providing senior level of support to the team, manage the escalated issues and requests from juniors adhering to SLAs.
• Experienced in creating high performance dynamic SSIS Packages and managing.
• Sound Experience in creating Parameterized tabular/ matrix reports, Charts, KPI’s.
• Sound experience in developing OLAP cube & writing MDX Queries/ Expressions.
• Added and removed Windows server features and roles such as Terminal servers (RDS), DNS, DHCP, etc
• Responsible for creating, reviewing and modifying various documentation, participate in CAB meetings, participate in on call duty 24x7.
• Maintained 33 Servers using IDERA Diagnostic Manager, IDERA Admin Toolset, RoboCopy Command and SCOM 2007.
• Good in handling refreshes, Planned Maintenances, Applying Patches.
• Mentored new team members and shared the knowledge.

Tech Lead

Confidential

Responsibilities:

• Created new SSIS Packages and made modifications to the existing SSIS packages based on customer requirements for First Allied Securities In corporation (FASI) San Diego, Los Angeles, US.
• Providing the reports that the financial consultants requests for by pumping the data from views to temporary views and then by creating indexes on the temporary views.
• Worked on Execution of the paths depending on the success, failure or Completion of other tasks with precedence constraints and expressions to determine the workflow.
• Supported the existing massive ETL Processing called BDM (Brokerage Data Mart) that pull data from different vendor systems

Tech Lead

Confidential

Responsibilities:

• Worked with 2 Projects at Confidential .
• Worked in Analysis Phase, Requirements gathering phase and creation of SSIS packages based on Customer requirements and testing them thoroughly for UAT for Arts & Entertainment (A&E) Client.
• Deployed to Broadridge Financial Services and worked for Pershing Client, Australia who is into Brokerage Services as an SQL SERVER Developer.

BI Engineer and Principle DBA

Confidential

Responsibilities:

• Monitoring Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing for 140 Customers across US for GE Healthcare, Burlington, Vermont, US.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Resolving the reporter issues on thick client that is installed on the customer’s end users machine.
• On-Call support to esteemed customers to resolve issues for business requirements.
• Good in solving request cases such as adding fields to Fact and Dimensions as requested by the customer and make sure that the field(s) is backfilled per customer’s request after adding them in reporting layer
• Good in handling the Scheduled Jobs (Reports that trigger after the ETL Process completion) & Web Dashboards.
• Identifying the corrupted Scheduled Jobs and Dashboards that are post load activities and bringing them back to track.
• Writing basic shell scripts to transfer the files from the InterSystems cache that works on wide variety of operating systems.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Implementation and delivery of BI platform solutions to develop and deploy ETL, analytical, reporting and scorecard\dash boarding on SQL Server 2008/2008 R2 using SSAS, SSIS/DTS, SSRS and Power BI.