SUMMARY:

• More than 6+ years of experience as a Database Administrator involved in design, installation, configuration, backup/recovery, query optimization, security administration, replication, T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS and Data-warehousing. Work experience spans across financial services, Mortgage, Federal Government projects and Healthcare Insurance domains on multi large-scale and highly visible projects.

TECHNICAL SKILLS:

• Expertise in server Installation, configuration, Design, Development, Administration, Services Management and with Business Intelligence in SQL Server Reporting and Integration of MS SQL Server 2016/2014/2012/2008 under Windows environment on a 24x7 large scale production environments in a Clustered (2-node/3-node)& non-clustered builds and upgrading Service Packs for multiple instances.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in writing complex T-SQL queries, optimizing T-SQL procedures using deadlocks
• Experience in user management for DBs, maintaining of databases, and providing security by assigning logins, server and database roles and server permissions.
• Experienced in configuring Database Maintenance Plan Wizard and scheduling it in accordance with the management.
• Created & maintained SQL objects like Tables, Constraints, User Defined Functions, Indexes, Views, Stored Procedures, SQL scripts, T-SQL queries for applications.
• Monitored production servers using tools like SQL Profiler, Windows Perform, Performance Counters and SQL server logs.
• Implemented and monitored different types of High Availability Solutions & Disaster Recovery scenarios (Clustering, Always On, Snapshot and Transactional Replication models, Log Shipping, Database Mirroring).
• Expertise in Microsoft Business Intelligence Tools BIDS like SQL server Integration services SSIS, SQL server Analysis services SSAS and reporting using SQL server Reporting services SSRS
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Involved in development and implementation of SSIS , SSAS and SSRS application solutions for various business units across the organization.
• Proficient in automation of administrative tasks like creating jobs, schedules, alerts, monitoring & troubleshooting jobs, and event notifications using Database Mail.
• Experience in working with 24/7 production environment following Standard Operation Procedures (SOP) and Service Level Agreements (SLA).
• Designed SSIS Packages which involved data from heterogeneous systems such as Oracle, MS Access and DB2 Mainframe systems and Migrated Data from Excel, MS Access, Flat file, CSV files, Oracle to MS SQL Server by using Excel Macros, IMPORT/EXPORT, BCP, DTS and SSIS Packages.
• Experience in creating reports using SSRS Ad-hoc, drill-down, drill-through, crosstab, sub-reports, pivot, tabular, parameterized reports and cascade parameterized reports
• Extensively worked on supporting 24x7 in a Production Environment and managing - Onsite & Offshore team.
• Involved in User Acceptance, system testing, bug fixing & documentation of the project.
• Flexible and versatile to adapt to any new environment and ability to work individually or in large teams involving long hours with strong inclination for finishing job before project deadline.
• Created SSIS packages to import and export Data, Text and Excel files to SQL Server database, and exchange data between different sources.

PROFESSIONAL EXPERIENCE:

Confidential, Little Rock, AR

SQL Database Administrator/Developer

Responsibilities:

• Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2 /2012/2008/2008 R2/2005 .
• Migrated servers from and and with In-place and Side-by-Side Processes.
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet. Involved in installation, configuration and developing of SSIS packages using BIDS.
• Experienced with High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server. Experienced with using SQL Server tools such as Profiler SSMS, SSIS, SSRS, SSCM, DMVs and system stored procedures.
• Designed ER diagrams and mapped the data into database objects and involved in normalization of the database in OLTP
• Deployed SQL Server databases in Virtual Environments using Hyper-V and VMware.
• Experienced with using 3rd party tools such as LightSpeed, Red Gate, and IDERA.
• Created variety of reports using SSRS including matrix report, parameter report, dashboard, charts, drill-down, drill- through, cascade parameterized report, configured report server and deployed reports on the web server with SharePoint.
• Involved in installation, configuration, development, deployment of Reporting Services using SSRS 2012/2008/2005
• 24/7 Production support on SQL Server Databases and Data warehouse.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. Developed Unit Test Plans for SSIS packages for checking functionality of component.
• Managing security patches, hot fixes, service packs, and evaluating the impact on performance before production deployment take place.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Worked on Active/Passive clusters to manage cluster resources and troubleshoot errors.
• Used log shipping, Always on Availability Groups and Mirroring for synchronization of databases and worked with Transactional Replication to achieve load balancing.
• Experienced with Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
• Worked on writing optimized complex SQL codes, stored procedures and scripts for maintenance and reporting purposes.
• Worked on data partitioning and data compression and demonstrated an understanding of database internals and application database components (e.g. triggers, functions, packages).
• Good knowledge in using DMVs and DMFs to find and solve Performance Issue, Data modeling concepts.
• Monitoring Event Viewer, SQL Error Logs and Log File Viewer for Software and hardware related errors.
• Expert in raising the Service Requests and keep tracking of SQL requests from customers.
• Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor

Confidential, Oakland, CA

SQL Server DBA/Developer

Responsibilities:

• Gather and analyze client requirements and planning stages of SDLC and documenting project and coding specifications and plan deliverables.
• Managed 275 database servers - monitoring working incidents and providing support.
• Created dashboard SSRS reports server projects and publishing SSRS reports to the report server tabular and matrix reports with aggregator functions and expressions.
• Set up maintenance tasks such as database backups, consistency checks, Database optimizations, and provide security for the database.
• Implemented SCOM to monitor aspects of SQL Server like database performance and health areas, database files, long-running jobs, blocking sessions, compliance.
• Implemented SQL Security and object permissions for creating and users and logins, assigning roles to the users, and managing user permissions.
• Managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Monitored and Performed ETL operations to support the data loads and transformations using SSIS to the Data Warehouse Server.
• Identified and worked with multivalve parameters for parameterized reports in SSRS
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet. Involved in installation, configuration and developing of SSIS packages using BIDS.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Created and Managed database backups, ensuring completion of scheduled database backups for Microsoft SQL Server 2012 databases.
• Created Clustered/Non-Clustered Indexes to improve performance of database access. Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Use the SQL Analyzer, and Profiler for studying the SQL statements and procedures
• Developed complex stored procedures to create various reports. Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Confidential

SQL DBA

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Setup log shipping between various sites to support planned and unplanned application failovers.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Configured the report viewing security for various users at various levels using Report Manager.
• Daily DBA routines included handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.