SUMMARY

• 5 years of experience in Database Administration, Database Design, Modeling, Development & Support of MS SQL Server 2012 in Production & Development environments.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server
• Experience in Always - on Availability Groups (AAG) and HA/DR Troubleshooting.
• Having Good Knowledge on MS SQL Server 2014.
• Experience in upgrading SQL Server from version and 2008R2 to 2012.
• Performed Log Shipping and implemented Replication as High Availability techniques.
• Experience in Database Mirroring as Disaster Recovery Solution.
• Experience in Creating Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions and other Transact-SQL (DDL, DML) statements for various applications.
• Worked with SSIS, SSRS& Crystal Reports for various BI requirements.
• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Tracked Server Activity, Query Performance and Disk usage activity statistics via Performance Data Collection.
• Expert in designing Relational Database Model, implementation and testing as per business needs.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Implemented new concepts like Data partitioning, Snapshot Isolation, Online Indexing, Try-Cache Blocks, DDL Triggers and DMV & DMF.
• Optimized the Disk space for performance using RAID and SAN.
• Experience in data migrating (using tools like DTS, BULK INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Experience in extracting, transforming and loading data (ETL) using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Intensive experience in Monitoring and Tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, Windows Performance Monitor.
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.
• Experience in creation of logins, users and configuring permissions and assigning roles to users.
• Experience in Database Backup and Disaster Recovery procedures like Log shipping.
• Worked extensively in Clustered environment (Active / Passive) to further increase scalability and stability of business critical systems.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 6 Terabytes.
• Experience in optimizing the query by creating various clustered, non-clustered indexes and indexed views.
• Experience in Migrating of SQL Server 2005 to SQL Server 2008 & SQL Server 2008R2 to SQL Server 2012 using suitable approach.
• 24 x 7 Production Database on Call Support. Excellent Analytical, problem solving and communication skills.
• Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.

PROFESSIONAL EXPERIENCE

Sr. SQL DBA

Confidential, Wayne, PA

Responsibilities:

• Managed security on Production and Development environments.
• Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
• Creating and maintaining various databases on Production and development environments using SQL Server 2005/2008.
• Created jobs to import/ export data obtained from various States to update the GIS servers.
• Installed and configured SQL Server Reporting Services.
• Installed necessary Service Packs for SQL server 2005, 2008R2.
• Installed SQL server 2005, 2008 and 2012 on a test environment to be the future production environment.
• Upgraded legacy 2000 databases to SQL server 2005/2008.
• Involved in Database Backup and recovery.
• Implemented high availability on the various servers using replication/mirroring.
• Tuned databases for better performance.
• Implemented and tested the point in time recovery of the production databases.
• Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
• Design/ developing SSIS (ETL) MDX developing components.
• Loaded the data into another data sources (Oracle, SQL Server) using SSIS.
• Created various SSIS packages based upon the requirement.
• Created various reports using SSRS.
• Created the logical and physical data modeling using Erwin tool.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Data migration using DTS services across different databases like Oracle, MS access & flat files.
• Contacted various users in gathering the requirements and documented the necessary changes.

Environment: Windows2000/2003, MSSQLServer 2000/2005/2008/2012 , Oracle10g/11g, SSRS, DTS, SSIS, BCP SQL Server Profiler, VB.NET, T-SQL, Erwin 4.0, Erwin 3.5.2, DBMoto, Database engine tuning Advisor, IIS.

SQL DBA

Confidential, Conway, AR

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (Flat files, Excel, Oracle DB2, and SQL Server).
• Extract and Transform data into Staging Database and load data into data warehouse to create fact table and dimension table
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Responsible for creating SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Used try - catch block to handle the errors and to store all the errors in a table to handle them later and to continue the flow of execution.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes. created worksheets and dashboards in tableau desktop
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Created and modified various complex Stored Procedures used in the application using T-SQL.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
• Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Tuned SQL query for better performance using SQL Profiler.
• Documented all work, so user can easily understand the flow of process.

Environment: Microsoft SQL Server 2012, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, Business Objects, C#.Net, Windows Server, MS Visio, Oracle 9i, MS Excel, Tableau.

Jr. DBA

Confidential

Responsibilities:

• Solid experience in database development and support. Database migration, SQL Server 2000 upgrade to SQL Server 2005.
• Database performance tuning, capacity planning, and troubleshooting.
• Expertise in RDBMS, data warehouse architecture and modeling, ETL and DTS/SSIS experience.
• Thorough understanding and experience in data warehouse and data mart design, star schema, snowflake schema, normalization and demoralization concepts and principles.
• Experience in SSIS (Integration Service), SSAS (Analysis Service), SSRS (Reporting Service).
• Hands on experience on SQL Server Notification Service, Service Broker
• Excellent T - SQL and database programming skills.
• Monitoring the trace files, and Alert log file.
• Solid experience in software development life cycle.
• Extensive experience in project management and execution involving multiple concurrent development projects with a proven successful track record
• Exceptional ability to gather and translate complex user requirements into practical, cost-effective software solutions.
• Creative and innovative thinker, bringing energy, enthusiasm and leadership to problem resolution.
• Consistent, well-organized and dependable performer with the flexibility to adapt to constantly shifting priorities.

Environment: MS SQL Server 2005, SSIS, SSRS, SSAS, T- SQL