SUMMARY

• 8+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 in OLTP and OLAP environments.
• Experience installing MS SQL SERVER 2005,2008,2008 R2,2012,2014; updating with hot fix and service packs
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• Extensive experience in implementing High availability and Disaster Recovery solutions like Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
• Extensively worked on Active - Active and Active-Passive Clustering.
• Implemented new features in MS SQL Server 2012 like Always on HADR in prod and non-prod environments.
• Implemented In place and Side by Side Migration of MS SQL SERVER 2000/ R2 and 2008R2 to 20
• Experience in developing T-SQL (DDL, DML, and DCL) statements.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Microsoft Certified Database Administrator (MCDBA)
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in using the DMVS, DMFS, SP PROC’s, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Expert in Data Integrity, Performance Tuning, Query Optimization
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
• Expert in creating Views, Indexes, Partitioning.
• Worked on Datatel's Colleague ERP System
• Have a good experience on Amazon Web Services
• One of the key benefits of cloud computing is the opportunity to replace up-front capital infrastructure expenses with low variable costs that scale with your business.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MS VISIO.
• ITIL Process implementation (Incident/Problem/Change/Release Management).
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Configured the AWE and /3 GB switch for the SQL server 2005 on 32-bit boxes.
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server.
• Experience in SQL Upgrades SQL and Building SQL Clustering.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, and Updating Statistics.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Having a good experience in Relational Databases
• Experience with Azure/AWS
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Having a good experience in XML
• Experience in using DMV and DBCC commands for various performance issues.
• Extensively used third party tools like Lite Speed, Fog light and Red gate.
• Auditing of database for users transactions, login and database action and removing orphan users
• Having a god experience in MDX Queries.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers
• Having a good experience in Epic Clarity Data Base
• Having a good experience in Cosmos
• SME utilizes Microsoft SQL Server 2005 for improved speed, scalability, security, and performance. This allows your business to grow to unprecedented levels through the benefits of SME.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Having a good experience in Database Engineering
• Microsoft Certified Systems Engineer (MCSE)
• Experience working on DATA MART
• Having a good experience in Capital Marketing
• Experience in creating SQL Server Reports using SSRS 2005 and 2008, 2012.
• Experience working on Hyper-V and VMware environments
• Experience working with Change control process/Change management
• Strong experience in mentoring junior team members, documentation and 24/7 on call production support
• 24*7 Production support experience

TECHNICAL SKILLS

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script, Shell, Sybase

Operating Systems: Windows 95/2000/2003/2008/2008 r2/2012/2012r2/XP/VISTA/7, Sun Solaris 9,VMware ESX servers

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Oracle 10g/11g, MS Access, MongoDB, SME

ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS, Crystal Reports, MOM, Kettle, Pentaho

DB Utilities: SQL Server Management Utility, Query Analyzer, Toad 8.0 version

Application Software: Visual Studio 2005/2008/2012 , Visual Source Safe, TFS, MS Office Suite

Data Modeling Tools: Erwin, Data Mart

Other Tools: Lite Speed, Red gate, Fog light, Spot light, Blade Logic, AltirisBmc Remedy, Pro Task, Jira Board, PCI Compliance, AWS, Microsoft SCCM.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr Sql Dba/Developer

Responsibilities:

• Gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Involved in database Schema design and development.
• Migrated Database from SQL Server to 2014.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files.
• Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Data marts are often used to provide information to functional segments of the organization. Data marts can also be used to segment data warehouse
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
• Expert in SSIS Deploying and Scheduling.
• Having good knowledge in Mongo Database design.
• Microsoft Azure SQL Databaseis acloud-based service from Microsoft offering data-storage capabilities as a part of theAzure Services Platform
• Anavailability groupsupports a failover environment for a discrete set of user databases, known asavailability databases, that fail over together.
• An availability group supports a set of primary databases and one to eight sets of corresponding secondary databases.
• Secondary databases arenotbackups. Continue to back up your databases and their transaction logs on a regular basis.
• We use FOGLIGHT for optimal database performance with non-stop data collection and instant metric-sensitive alerts.
• We use enterprise-level view of database health and automated performance analysis to quickly identify and fix problem servers and resource areas.
• We Maximize database performance and availability with this robust SQL Server monitoring tool.
• We can extend System Center Configuration Manager to manage PCs, Macs, and Unix/Linux servers along with cloud-based mobile devices
• We used to develop the product by using Microsoft for managing large groups of computers runningWindows NT, Windows Embedded, OS X, Linux orUNIX,
• TCP/IP (Transmission Control Protocol/Internet Protocol) is the basic communication language or protocol of the Internet.
• It can also be used as a communications protocol in a private network (either anintranetor anextranet).
• When you are set up with direct access to the Internet, your computer is provided with a copy of the TCP/IP program just as every other computer that you may send messages to or get information from also has a copy of TCP/IP.
• The Clarity database is a large subset of data that comes from the Penn Chart (Epic) application.
• The Clarity database is used to run complex, data-intensive reports without impacting the user-facing Penn Chart environment.
• If your reporting needs include large quantities of data, long date ranges, complex mathematics, summarization, or data integration with other systems, then Clarity is your tool Because data needs to be extracted from Penn Chart database to the Clarity database, Clarity reports don’t include real-time information.
• The Clarity Test Environment contains data from the Penn Chart TST environment. This environment is updated on an as needed basis for testing of changes to the productions environment.
• Extensible Markup Language(XML) is amarkup language that defines a set of rules for encoding documents in a format which is bothhuman-readable andmachine-readable .
• The design goals of XML emphasize simplicity, generality and usability across theInternet . It is a textual data format with strong support viaUnicode for differenthuman languages .
• We use to collaborate with IT teams and management to devise a data strategy that addresses industry requirements
• We will build an invent the data needed to implement the architecture
• We used to do research for new opportunities for data acquisition
• We will identify the data and evaluate current data management technologies
• We create a fluid, end-to-end vision for how data will flow through an organization
• Amazon Web Services (AWS) offers you the flexibility to run Microsoft SQL Server for as much or as little time as you need.
• Amazon Web Services (AWS) began offering IT infrastructure services to businesses in the form of web services -- now commonly known as cloud computing.
• One of the key benefits of cloud computing is the opportunity to replace up-front capital infrastructure expenses with low variable costs that scale with your business.
• With the Cloud, businesses no longer need to plan for and procure servers and other IT infrastructure weeks or months in advance.
• Instead, they can instantly spin up hundreds or thousands of servers in minutes and deliver results faster.
• Today, Amazon Web Services provides a highly reliable, scalable, low-cost infrastructure platform in the cloud that powers hundreds of thousands of businesses
• Amazon Web Services (AWS) is a securecloud services platform, offering compute power, database storage, content delivery and other functionality to help businesses scale and grow.
• Explore how millions of customers are currently using AWS cloud products and solutions to build sophisticated applications with increased flexibility, scalability and reliability.
• You can select from a number of versions of Microsoft SQL Server, as well as choose between running it on Amazon EC2 or Amazon RDS.
• Identified and Defined Key Performance Indicators in SSAS 2005/2008.
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).
• Vertica Systemsis ananalytic database management software company.
• It is a cluster-based, column-oriented Vertica Analytics Platform is designed to manage large, fast-growing volumes of data and provide very fast query performance when used fordata warehouses and other query-intensive applications.
• MDX Query is a language forrelational databases . We use a calculation language, with syntax similar to spreadsheet formulas.
• Involvingactiveparticipation, practicalexperienceofequipment in Hands ON Experience
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dashboards using Microsoft PerformancePoint service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.

Confidential, NC

Sql Dba/Developer

Environment: SQL Server 2005, T-SQL, DTS, Lite speed, Double-Take software, SQL backup and BMC Remedy.

Responsibilities:

• Monitoring database performance using SQL Profiler and the DB’s percent log space for all database servers using SCOM and Windows Performance Monitor counters.
• Maintained the Active-Passive Clustering as a disaster recovery solution
• Implemented different types of Replication Models like Snapshot and Transactional Managed the use of disk space, memory and connections.
• Performed DBCC utilities and fixed data corruption in application databases.
• Configured and maintained database mirroring for high availability.
• Using log shipping for synchronization of database.
• Monitored Databases for lock escalation, DeadLock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries using SQL Profiler.
• Traced long running queries and deadlocks using SQL Profiler
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers maintained Referential Integrity.
• We work on data models to develop database structures
• We Design, document, construct and deploy database architectures and applications (e.g. large relational databases)
• Integrate technical functionality (e.g. scalability, security, performance, data recovery, reliability, etc.)
• Database engineers, who may work as either applications or systems software developers, are generally employed by computer systems companies to design and monitor complex databases.
• They must make sure that a database is operational and provides valid and relevant data.
• An in-depth understanding of computer software, database technologies and programming is required to work as a database engineer.
• Analyzed designed, developed, implemented and maintained the instances of databases. Worked on monitoring and tuning the SQL scripts
• Worked with T-SQL development and performance tuning in T-SQL code. Participated in Performance Tuning of Code using execution plan and SQL profiler.
• Added Indexes to improve performance on tables. Used multiple join statements to retrieve data from multiple tables.
• Vertica's specialized approach aims to significantly increase query performance in data warehouses, while reducing the total cost of ownership by reducing the hardware footprint.
• Thecosmosis theuniverse regarded as a complex and orderly system.
• Configuring and implementing SQL Server contained database.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions. Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Global Customer interactions through mails/telephonic etc.
• Normalization and Denormalization of tables. Developed Backup and Restore scripts for SQL Server 2005. Installed and Configured SQL Server 2005 with latest service packs.

Confidential, Austin, TX

Sql Dba/Developer

Environment: SQL Server 2005/2008/2008 R2/2012 with clustering, Sybase, T-SQL, LiteSpeed, Windows 2000, Oracle, VB and ASP.

Responsibilities:

• Installed and configured SQL Server 2005/2008/2008 R2 on the server and client machines, provide connections and manage databases.
• Created and maintained various databases for Production, Development Servers using MS SQL Server 2005/2008/2008 R2.
• Planning the location of data, indexes, and Transaction log files on the disk.
• Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Resolved locking and blocking issues.
• Tuning the Production server to get the performance improvement.
• Running Index tuning wizard for optimal query performance.
• We implement measures to ensure data accuracy and accessibility
• We will constantly monitor, refine and report on the performance of data management systems
• Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery.
• Experience working with IDERA for Performance Monitoring, Dead Lock, and Blocking.
• Monitoring SQL Server Logs, Application logs and analyzing the logs.
• Provided 24/7 support to SQL application developers in implementing them production server.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Created the SSIS packages for executing the tasks, created the Jobs and scheduled for daily running.
• A batch is a collection of one or more SQL statements sent in one unit by the client.
• Each batch is compiled into a single execution plan.
• If the batch contains multiple SQL statements, all of the optimized steps needed to perform all the statements are built into a single execution plan.
• Involved in Change Data Capture process.
• Vertica Analytics Platform Community Edition is available for free with certain limitations, such as a maximum of one terabyte of raw data, three-node (servers) cluster, and limited support.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, production support and Project review with client.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• To design & develop data models and perform forward and reverse engineering using data modeling tools like ERWIN.

Confidential, NY

SQL Server DBA

Environment: MS SQL Server 2000/2005/2008 , Windows 2000/2003 servers, .NET, MS Access.

Responsibilities:

• Installing and configuring and tuning and providing 24X7 support for SQL Server 2000/2005/2008 R2
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on the SQL Server 2005 production databases.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request.
• Worked extensively on SQL Server Reporting Services to generate reports.
• Created Linked Servers between 2005 and 2008 R2 servers.
• Involved in Migration from SQL Server and 2008
• Created Database Diagrams using Erwin Data Modeler.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• The Vertica Analytic Database runs oncluster ofLinux -basedcommodity servers .
• It is also available as a hosted DBMS provisioned by and running on theAmazon Elastic Compute Cloud .
• We meld new systems with existing warehouse structures
• We will produce and enforce database development standards
• We will maintain a corporate repository of all data architecture artifacts and procedures
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Restore Development and Staging databases from production backups as per the requirement.
• Extensively used SSIS to move data from text files to SQL Server.
• Capital markets aremarkets for buying and sellingequity anddebt instruments.
• Capital markets channel savings and investment between suppliers ofcapital such asretail investors andinstitutional investors, and users of capital like businesses, government and individuals.
• Capital markets are vital to the functioning of aneconomy, since capital is a critical component for generating economic output.
• Capital markets includeprimary markets, where newstock andbond issues are sold to investors, andsecondary markets, which trade existingsecurities .
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designedandimplemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Involved in resolving dead lock issues and performance issues.

Confidential

SQL Server Developer/DBA

Environment: MS SQL Server 2000/2005, T-SQL, Windows NT/2000/ 2003

Responsibilities:

• Installation and configuration of MS SQL Server 2003/2000/7.0
• Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
• Created ER diagrams
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning.
• Involved in Optimization and normalization of database and tables.
• Involved in conceptual and physical modeling of data using Erwin tool.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing the physical design for database.
• Writing complex Stored Procedures to meet the business requirements.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Designing and building data load procedures, using MS SQL Server.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Responsible for transferring of database and database objects from Development to Production Server using DTS.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.