SUMMARY

• I am an MS SQL Server Database Administrator, experience with System Design, Data Warehouse concept, Development and Support of Microsoft SQL Server offering over 7 years focusing on (production, development and QA environment), Data architecture, Data Enrichment and application of Technology.
• My strengths include Oracle development, implementation, upgrades, Database Management Technology in cluster, data administration, strategic planning, data warehousing, Failover Clustering, Database Mirroring, Log Shipping, Replication, relational database design, projects and business process management and Database and ETL Development.

TECHNICAL SKILLS

Languages: SQL, T - SQL, XML, PL/SQL, C++, VB, VBA, HTML, ASP, Java Script and Shell Script, CL, CR and Power Shell

Software: SentryOne, Delphix, SQL Compliance Manager (Idea), Veeam Replication, SQL Monitor (Redgate) APEXSQL,SQL*Plus, Data Collector, Active Directory (AD), Jira, XML, Tidal Job, Oracle SQL Developer, Quilk Sense, TOAD Molder, Visual Studio Database Projects, SVN,SQLCMD,SQL*Loader, Git, PowerBuilder, MS FrontPage 2000/98, Visual Source Safe, MS office XP/2000/98, Visible Analyst 6.0, Visio, OLAP, Data Warehouse, DB Artisan, Netcool, MOM, Sybase Central, Toad for Oracle/SQL, Relativity, Microsoft Exchange 2010, 2013, Microsoft SharePoint, Microsoft SQL Server management, PerfMon, MS-Access, MS-Excel, SQL,T-SQL,HTML. Visual Studio 2005/2008/2015 , Crystal Report, SQL Profiler, MS Visio, NetIQ & S6532potlight, DVM, Performance Data housing, Team Quest, Precise, Idera, Team Quest, Precise, Foglight DSTEST, HALDB AND Fast path

Database: SQL Server 2016/2014/2012/2008/20005/2000/7.0/6.5 , SQL Oracle Developer, Quick Sense, MS Access Database, Toad Data Modeling, OLTP, DTS/SSIS Analysis Services, SSAS, SSRS, BCP, IMS Database

Systems: Windows 7,8/XP/NT/2000/98/95, UNIX, Linux, Power Shell, HP, SAN, BizTalk, IIS, Commerce Server 2007, Virtualization.

PROFESSIONAL EXPERIENCE

Confidential

SQL DevOps Admin

Responsibilities:

• Installation, Configuration and Administration of SQL Software and Individual database(s)
• Installation of software upgrades and database schema changes
• Ensure software environment is in supported release and that patches are reviewed and applied as demand necessary
• Monitoring of database performance and making configuration changes to tune the database for optimal performance
• Documenting procedures and performing database backup, rollback, and recovery activities
• Defining and maintaining database security, trouble shoot database and associated problems
• Schedule maintenance tasks to limit impact to application and data availability
• Performs data managements activities including data transfer, data replication, etc.
• Coordinate upgrade activities with Tech support personnel responsible for the application
• Monitor performance and resource usage and plan future storage requirements
• Assist in and coordinate data conversion activities with the vendor and application support personnel
• Develops and documentation procedures to necessary restore the environment in the event of a disaster
• Communicate regularly with user and management apprising them of activities that will impact them and the status of problems as they occur
• Stay informed of trends in the industry, attend seminars and classes to keep abreast of changes and new products that support the SQL environment
• Complies with all applicable agency policies and procedures, including safety and standards of conduct.
• Defines and create environment for development and new release deployment
• Provides database design support including data normalization
• Provides implementation support
• Defines and maintains database standards
• Develops production migration procedures
• Maintenance database documentation

Environment: Server 2008R2, 2012, 2014, 2016, Visual Studio 2010, 2015, GITHub, Red gate (SQL Compare), SentryOne, SentryOne Plan Explorer, JIRA, Workfront, Delphix Engine, Vista HRMS, Thycotic Secret Server, Control-M Scheduler 9.0.18, PowerShell Automation, PLSQL Developer

Confidential

SQL DBA Administrator

Responsibilities:

• Performs DBA activities associated with the design, deployment, use, control, monitoring, support, and performance of DBMS.
• Perform database administration activities for all environments (production, staging, Persistent and development) including: database refreshing, job monitoring, release deployment, installation, configuration, process monitoring, database backup & restore, and database server upgrades
• Modifies existing databases and database management system or directs programmers and analysts to make changes with appropriate database objects such as indexes, tables, partitions, triggers, constraints, store procedures, large objects, views etc.
• Diagnoses, Troubleshoots and resolves database related issues including storage, performance, availability, data integrity and database security.
• Performs database error log analysis, troubleshoots and quickly provides solutions.
• Monitors and measures database performance by incorporating storage management strategies into multi-platform, enterprise-wide solutions.
• Develops and coordinates backups/recovery features and recommends the procurement of tools and third-party solutions that enhance DBMS support, availability and performance.
• Suggests changes in programming techniques and methodologies to enhance DMBS.
• Assists the application development team with software releases and client/server database design, development, load-testing and validation efforts.
• Recognizes and identifies areas where DBMS solutions will enhance application availability, performance and user satisfaction.
• Translates application requirements into effective database structures, on-line queries, extracts and reports as needed.
• Assists with the formulation, documentation and publication of organizational standards governing database design, use, control, monitoring, support and performance.
• Provides expertise to the application development team by analyzing the information requirements of new and existing systems, and the migration of legacy systems to client/server or open system solutions.
• Creates down-time requirements ahead of schedule to lessen impact on development team.
• Assists in the selection of education programs and training supporting effective use of DBMS technology within the organization.
• Informs the R&D Tech team of important industry developments, advances and trends in DBMS-related technologies.
• Maintains a positive and cooperative working relationship with all departments to optimize communication and customer satisfaction.

Confidential

SQL Data Developer

Responsibilities:

• Design, develop, implement, optimize, and support ETL processes using SSIS
• Assist in the problem identification, analysis, design and implementation of development as required.
• Developed high Level Design of ETL DTS Package in MS SQL Server 2012 for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data)
• Involved in the Database design (Logical Data Modeling, Physical Data Modeling and Conceptual Modeling)
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions, created tables and performed data imports and restores for successful migration, Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights
• Generated Data Enrichments Applications (DEA) to import custom hierarchies into the testing
• Generated Framework for GL Trial Balance and data that was used to replaced 250+ UDA’s manual Process with Automated generation through the help of UDA Helper Application.
• Participated actively in determining the specific roles of the Data Criticality Engine Verse the reconciliation Framework and how to integrate Data criticality into the Information Governance metadata.
• Created SSIS Packages using fuzzy lookup, derived columns, conditional split, Term extraction, aggregate, execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text File, MS Access and CSV files.
• Created SSIS packages for different applications - to Truncate & load data, appending data to the existing data, update existing records before inserting new records for different packages daily at specific EST for different environments (DEV, UAT & PROD)
• Deployed the packages on staging and production, Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleaned, and validated data from XML file into database using XML source.
• Set SQL server configurations for SSIS packages and configured logging including windows event log and XML source.
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
• Deployed and processed SSIS Packages and SSRS Reports weekly to update information (As per business logic) by using SQL Server Agent and windows Scheduler

Environment: Microsoft SQL Server 2014, T-SQL, SQL Integration Service (SSIS), Oracle SQL Developer, JIRA, Microsoft SharePoint, Tidal Job, SQL Reporting Services (SSRS), APEXSQL, Data Warehousing, MS Access, MS Office 2010, Quick Sense.

Confidential

Lead SQL Server DBA

Responsibilities:

• Diagnosed & troubleshoot issues, conducted performance tuning for optimizations.
• Replication of data using Transactional method.
• Installed SQL Server in Cluster and upgraded SQL Server from SQL 2008 R2 to SQL Server 2012
• Set up log shipping, management strategy, Capacity planning and Maintenance Plan.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases. Created Indexes for the quick retrieval of the data from the database.
• Used Execution Plan, SQL Profiler and Database engine tuning advisor to optimize queries and enhanced the performance of databases.
• Implemented and enforced database encryption using TDE (Transparent Data Encryption).
• Created automated processes for activities such as database backup and recovery processes and SSIS Packages run sequentially using SQL Server Agent job.
• Used Event handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre-and Post-Execution, On Task failed etc.)
• Generated parameterized / Drilldown reports using SSRS and Crystal Reports. Created snapshot reports. Used dynamic parameters in SSRS to enable/ disable the parameters based on user selection.
• Scheduled daily and weekly jobs using SQL Server Agent.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, data mining models, developing reports using MDX, and SQL.
• Exported and generated the tabular report using excel power pivot.
• Maintained & managed Database security and installed monitor tools on the Server.
• Participated in project meeting and ad-hoc ticketing system issues .
• Participated in the database team on-call rotation.

Environment: Microsoft SQL Server 2012, TSQL, SQL Integration Service (SSIS), SQL Reporting Services (SSRS), Data Warehousing (SSAS), MSIIS 7.0, MDX, MS Office 2010, Oracle 10g, Crystal reports.

Confidential

SQL Server DBA

Responsibilities:

• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Created complex Stored Procedures, triggers, cursors, tables, views and SQL joins and statements for applications by using T-SQL.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
• Created and configured the database, with 2 file groups, created the tables having required constraints.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Performance tuning of SQL queries and stored procedures using SQL Profiler, DTA and Index Tuning Wizard.
• Created SSIS packages through ETL Process to vendors in which records were extracts from Flat file an Excel sources and loaded daily at the server.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and SCD I and SCD II changes.
• Participated in identifying Data migration issues and resolved them.
• Created Matrix, Drilldown, Snapshot Reports have been generated to identify the best business vendors.
• Extensively worked with Monitoring and Analysis services of vendors to provide the best possible KPIs, Analytical Grid and scorecards to build the best possible Dashboards for the Inventory Manager for better decision making.
• Designed BI portals in SharePoint server 2010 to vendor reports, dashboards and scorecards.
• Involved in deploying, configuring and managing the reports using SSRS and used report subscription to publish reports.

Environment: MS SQL Server 2008R2, SQL Profiler, TSQL, SQL Integration Service (SSIS), SQL Reporting Services (SSRS), Data Warehousing (SSAS), MSIIS 6.0, MDX, MS Access 2003, Windows Server 2003.

Confidential

SQL Server DBA

Responsibilities:

• Managed and SupportedMS SQL Server 2000/2005 Production Databases.
• Installed SQL Server in Cluster and upgrade SQL Server from SQL 2000 to SQL 2005.
• Troubleshoot and Conducted performance tuning for applications.
• Set up log shipping and management strategy and Capacity planning.
• Configured database in SQL 2005 to automate operation alert.
• Maintained and supported developers for SSIS/DTS, SQL Analysis Services SSRS.
• Migrate DTS to SSIS and Implemented SSIS to load data into DW systems.
• Supported large web applications and large Data warehouse systems.
• Backup Oracle database and Monitor oracle jobs.
• Managed and Supportedlarge amount of MS SQL Server 2000/2005 database in high.
• Availability environments including Cluster and Log shipping, Replication.
• Lead DBA for consolidating MS SQL Server databases on HP Polyserve Matrix.
• Conducted performance tuning for applications.
• Performed database Backup and Recovery, lead the Disaster Recovery.
• Upgrade MS SQL Server 7.0/6.5 to SQL 2000 and from SQL 2000 to SQL 2005.
• Wrote batch files to Managed databases and Migrate data across Server.
• Converted database from Froxpro to MS SQL 2000.
• Automated DBA activities to help ensure the high availability of the Server.
• Apply SQL Service patches and managed SQL server security, Support SharePoint in SQL.
• Supported SSAS and Managed OLAP database for Data warehouse for financial business.
• Setup log shipping and replication.
• Built database Triggers and Referential Integrity Constraints to implement business rules.