Sql Server Project

Akshit Mehta

Contact no.: 201-***-****

Email ID: ***********@*******.***

Summary:

• 7 years of IT experience in Database Administration, and Support of MS SQL Server 2008, MS SQL

Server 2005 and MS SQL Server 2000 in Production, PStage, QA, Test, Development in Standalone

and Cluster Server Environments.

• Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design,

Development and Implementation

• Experience in installation, configuration of MS SQL Server 2000 on Windows NT/2003/2008 servers

and also worked on migration from SQL Server 2000 to SQL Server 2005.

• Experience in installing SQL Server in Virtual environment.

• Experience in backing up databases on NetApp.

• Proficient in Designing and Documentation of SQL Server Strategies and plans.

• Experience in database backups/restoration and recovery of NT server/SQL Servers

• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS

and SSIS utilities.

• Experience in creating reporting using SSRS

• Experience in configuring, administering and maintaining Replication.

• Experience in performance monitoring and performance tuning by implementing efficient schemas,

Optimizing queries, Tuning indexes and Database Consistency Checks using DBCC Utilities.

• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server

Agent, and SQL Profiler.

• Experience in working with version controlling tools for managing SQL scripts and changes that are

going to production.

• Experience in Installing and Configuring Failover Clustering for high availability in Active/Passive or

Active/Active and also combined clustering and database mirroring

• Setup, Reconfigured, and Monitored log shipping of production databases and also carried out role

changes, role reversals, and positioning the monitor server.

• Experience in resolving database performance issues, database capacity issues and distributed data

issues.

• Experience with OLAP and Datawarehouse/Data Mining.

• Excellent analytical & interpersonal communication skills, able to work both in teams and

individually.

Education:

• M.S. in Electrical and Computer Engineering.

• B. E. in Computer Engineering.

Technical Expertise:

Networking: Telnet, TCP/IP, WAN/BIGIP, LAN, Subnetting, DHCP, DNS/WINS, and FTP.

RDBMS: SQL Server 2005, SQL Server 2000, SQL Server 7 and Access.

Languages: T-SQL, C#, C++, VB, .NET.

Operating Systems: Windows 2000 Server, Windows 2000 Advanced Server, Exchange 2003,

Windows Server 2003.

SQL Server Tools SSRS, SSIS, ERWin, Visual Studio, Litespeed, Tivoli Monitoring, Control-M.

Storage SAN, NetApp, EMC BCV Split

Virtualization VMWare, VMotion.

Professional Experience:

DowJones (New York, NY)

SQL Server DBA/Developer April 2009 - Present

Dow Jones & Company is a subsidiary of News Corporation, A leader in news and business information

world-wide.

Dow Jones's consumer media business offers business and financial information to the consumer market

around the globe. Its publications and Web sites are some of the best known and most respected brands,

regularly engaging more than 42 million readers worldwide.

The Dow Jones Enterprise Media Group provides high value, hard-to-find, premium content that

businesses and financial services firms demand, including real-time news, research, aggregated content

and information solutions. It creates targeted products and services specifically for professionals in Wealth

Management, Investment Banking, Investment Management, Sales & Trading, B2B Sales, Researchers &

Knowledge Workers, Public Relations & Corporate Communications, Private Markets, Risk &

Compliance and Energy & Commodities.

Dow Jones Local Media Group includes eight daily and 14 weekly franchises that are distinguished by

award-winning journalism and products crafted for the interests and needs of their communities. Operating

in seven states with a Sunday circulation of more than 300,000 readers, we also publish quality lifestyle

magazines and a specialized business digest. Each local media franchise is autonomous, investing

responsibility in local management to serve its region best.

Responsibilities:

• Database Architect for Wall Street Journal financial job search website www.fins.com.

• Discuss the application requirements with Product Management and Developers and create database

design.

• Propose Design and architecture improvements.

• Verified Database scripts for SQL Injection.

• Prepared the detail project layout, analyzed existing technology involved and documented work

performed.

• Configure database mirroring as High availability/ Disaster Recovery solution.

• Created database objects like Tables, Views, Indexes etc.

• Created and modified Stored Procedures, Triggers, Jobs etc.

• Manage/Modify Content provided by the FINS Editorial team for the Website.

• Created DML Scripts for modifying data based on the business requirements.

• Created DDL SQL Scripts for creating and modifying database objects.

• Configured the database to communicate with Mass mailing application - Strong Mail.

• Manage access rights to the database.

• Worked with QA team in performing Stress Test for the application.

• Created DTS/SSIS packages to import and export data from various flat files.

• Automate job loading provided in XML Feeds.

• Responsible for database creation, database tuning, performance planning and database administration.

• Perform DBA tasks like creating maintenance plans, checking job failures and troubleshooting issues.

• Managing the database in production and all the lower environments.

• Generate reports on a daily basis for Business.

• Refresh production database in lower environments.

• Create scramble scripts to protect user information in testing environments.

• Experience in managing Source Code using TFS

• Experience in transitioning the project to Offshore team in India.

• Created tickets for weekly deployments to production.

• Experience of working in fast paced environment and under pressure.

Environment: MS SQL Server 2005, Windows server 2008, Strong Mail, Remedy etc.

Harmony Information Systems (Reston, VA)

SQL Server DBA/Developer Sept 2008 – April 2009

Harmony Information Systems, Inc. is the leading provider of information management solutions for both

government and private provider human services organizations. Harmony helps agencies maximize client

outcomes, improve the efficiency of service delivery, and ensure funding compliance by offering

automated, easy-to-use, web-based software.

Responsibilities:

• Created database objects like Tables, Views, Indexes etc.

• Created and modified Stored Procedures, Triggers, Cursors etc.

• Created never failing DDL SQL Scripts for creating and modifying database objects.

• Created DTS/SSIS packages to import and export data from various flat files.

• Responsible for database creation, database tuning, performance planning and database administration.

• Perform DBA tasks like installing and configuring SQL servers, creating maintenance plans, checking

job failures and troubleshooting issues.

• Analyzed application upgrade logs to confirm that the database has been upgraded correctly at the

client location.

• Worked as IT Production support person helping the Clients in solving problems faced by them.

• Involved in planning and administration of data migration and performance tuning to achieve code

efficiency and effectiveness of the system.

• Prepared the detail project layout, analyzed existing technology involved and documented work

performed.

• Work with Offshore QA team for discussing various use cases and test scenarios.

• Work on tickets created by the clients.

• Created batch files in DOS.

Environment: MS SQL Server 2000/2005, SSIS, SSAS, Windows server 2003, Idera, Redgate SQL

Compare, Redgate SQL Data Compare etc.

Blue Cross and Blue Shield of North Carolina (BCBSNC) Durham, NC

SQL Server DBA Sept 2007 – Sept 2008

Blue Cross and Blue Shield of North Carolina (BCBSNC) is a leader in delivering innovative health care

products, services and information to more than 3.5 million members, including approximately 815,000

served on behalf of other Blue Plans. The company offers its members Blue ExtrasSM value-added

programs, which provide discounts and information on a wide variety of health-related services at no

additional cost. BCBSNC also offers life, dental and disability insurance products. For 74 years, the

company has served its customers by offering access to quality health care at a competitive price and has

served the people of North Carolina through support of community organizations, programs and events

that promote good health.

BCBSNC's HMO product has earned Excellent Accreditation from the National Committee for Quality

Assurance (NCQA), an independent, not-for-profit organization dedicated to measuring the quality of

America's health care. In addition, in July 2002, Blue OptionsSM plan became the first Preferred Provider

Organization (PPO) plan in the state to be accredited by NCQA, earning Full Accreditation - the highest

level available for PPO plans.

Responsibilities:

• Support ~300 SQL Server databases including all environments.

• Lead and direct the work of others in the database applications team and control workflow to meet the

project timeline.

• Installed MS SQL Server Cluster Server and configured SQL Server 2000/2005 on Windows 2003

Advanced Server.

• Clustered environment setup using SAN for shared disk, Backup the database on NetApp which was

copied to tape daily.

Responsible for database creation, database tuning, performance planning and database administration.

•

Consult with the team members, Data Management, System Engineers and Infrastructure team for

•

database configuration.

Identified existing Server and Database Architecture environment for server migration, including all

•

documentation process to support SQL 2005.

Participated in project bidding with engineering team and outlined the expectations for project and

•

budget requirements. Maintained communication with engineering team to monitor progress and

submit reports to project committee.

Write stored procedures for database maintenance.

•

Monitor daily backup of databases on production servers.

•

Monitor and schedule existing/ new jobs on production server.

•

Involved in planning and administration of data migration and performance tuning to achieve cost

•

efficiency and effectiveness of the system.

Provide technical support to project team members, and all application users.

•

Provide 24*7 on call support to production databases.

•

Analyze the existing database environment and provide guidance for implementation.

•

Involved in development activities included hardware and network specification, installation and

•

configuration, and participation in database design, architecture and SQL scripting.

Created Tivoli Situations for monitoring databases.

•

Create and schedule Control-M jobs for on demand SQL Server jobs.

•

Install SQL 2005 in Virtual Environment on Dell R900 servers.

•

Use VMotion to failover the Virtual server to a new node.

•

Environment: MS SQL Server 2000/2005, Windows Server 2000/2003, DTS, NetApp, Tivoli, Control-M

Homestore Westlake Village, CA July 2006 – Sep 2007

SQL Server DBA/Developer

Homestore brings a world of real estate and housing onto the web. It is a leading supplier of media and

technology solutions that connect real estate professionals to consumers before, during and after move.

For the last ten years, Move, the new Homestore®, has been providing information and decision support

tools for consumers looking for home and real estate-related information on the Internet. Visitors to

Move’s Web sites, including REALTOR.com®, move.com™ (formerly Homestore.com®, RENTNET®

and HomeBuilder.com®) and seniorhousing.net™ have access to the most comprehensive selection of

existing homes for sale, new homes, apartments for rent and senior housing.

Responsibilities:

• Involved in Data modeling, designing and building relational databases.

• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity

depending on user requirements and converting them into technical specifications.

• Responsible for MS SQL Server 2000, configuration, tuning and provide 24 X 7 dedicated support to

all Production, development and clustered servers.

• Performed all aspects of database administration, including data modeling, backups and recovery.

• Configured Transactional replication between Primary Server and Read–Only server, with separate

Distributor server and experience in troubleshooting replication problems.

• Additionally, designed and implemented a disaster recovery system.

• Configured the Log shipping and created the Standby server.

• Running Index tuning wizard and rebuilding indexes for faster query response.

• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and

statements for applications.

• When we had 3000 user connections solved latching issues by creating Read – Only Server using

replication.

• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.

• Monitor connections, locks and performance of SQL server.

Assign permission to user(s), role(s), and object. Support column level permission. Administrate

•

security for server’s logins (Windows and SQL Accounts).

Creating different Data Mining models.

•

Prepared Estimates for Database, table size growth.

•

Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.

•

Expertise in Security Issues such as creation and granting permissions on various Objects.

•

Environment: MS SQL-Server 2000, DTS, SQL Diagrams, ERWin, Windows 2003 Server, MS Access,

Microsoft Analysis Services, Diagnostic Manager, Litespeed Backup Software

Factiva, NJ May 2006 - July 2006

SQL Server DBA

Factiva, a Dow Jones & Reuters Company, provides essential business news and information together

with the content delivery tools and services that enable professionals to make better decisions faster. It was

a short term project to migrate the data warehousing databases from SQL Server 2000 to SQL Server

2005.

Responsibilities:

• Verify the Database before upgrade and check for compatibility in terms of conflict reserve words and

unsupported feature.

• Approach to Migration that includes detach the existing databases and copy it through network and

attach in SQL Server 2005.

• Change the Database compatibility level to 90.

• Review SQL Server error log and event log for any messages related to the migration.

• Run Update Statistics on all table after migration.

• Linking SQL Server 2005 with SQL Server 2000.

• Migrating DTS packages, Scheduled Jobs and Maintenance Plans.

• Migrating OLAP database from SQL Server 2000 Analysis Services to 2005 SSAS using the

migration wizard.

Environment: MS SQL Server 2005 (x64), MS SQL Server 2000, Microsoft Windows Server 2003

Enterprise x64 Edition.

Lincoln Financial Advisory, PA July 2005 – May 2006

SQL Server DBA/Developer

Lincoln Financial Group sells a wide variety of financial products and solutions through Financial

Advisors (LFA): Mutual Funds, Managed Accounts, Retirement Solutions, Life Insurance, 401(k) and

403(b) Plans, 529 College Saving Plans, Institutional Investments and Financial Planning and Advisory

Services. The Account Aggregation Reporting Framework provides LFA planners and Advisors the ability

to search for their clients based on a various parameters such as: First Name, Last Name and SSN and

view select from a list of reports that are required to be generated or printed. The development required

close interaction with the business user’s technical infrastructure team of LFA.

Responsibilities:

• Configured Development and Test Servers

• Created and maintained Meta Data for the SQL Server Database as part of the system documentation

• Installation and configuration of MS SQL Reporting Services.

• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server

to populate data from various data sources, creating packages for different data loading operations for

application like MS Excel.

• Installation of Replication Server, Configuration and Monitoring the replication between two sites,

implemented Transactional Replication, writing scripts for automation, for creating publications,

articles and running the snapshot agent job, so that the same scripts can be used from system test to

production

Managing the use of disk space, memory and connections

•

Running DBCC consistency checks, and fixing data corruption in application databases

•

Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it

•

Environment: SQL Server 2000, IIS 4.0, Windows 2000

Verizon, NJ Sep 2004 – July 2005

SQL Server DBA/Developer

Based in New York, Verizon is a leader in delivering broadband and other wireline and wireless

communication innovations to mass market, business, government and wholesale customers. It operates

America’s most reliable wireless network, serving nearly 55 million customers nationwide and operates

one of the most expansive wholly-owned global IP networks. Verizon has deployed the nation’s most

advanced fiber-optic network to deliver the benefits of converged communications, information and

entertainment services to customers.

Responsibilities:

• Installation of MS SQL enterprise servers on production, test and development boxes.

• Extensively used SQL executive, SQL profiler, DTS, and SQL mail services.

• Partitioned lot of tables, which have frequent inserts, deletes and updates to reduce the contention and

to improve the performance.

• Dropped and recreated the indexes on tables for performance improvements.

• Drop and add users, logins, aliases, and groups to the databases and granting/revoking permissions on

Database objects.

• Auditing stored procedures for optimization and improving performance.

• Data Transfers between various servers using BCP

• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly

basis.

• Maintained Cluster environment.

• Analyzed SECURITY on Cluster Environment.

• Worked on SOX project.

• Created Database Security by giving proper permissions to users and Admins.

• Performance tuning on the Production, QA and development Servers.

• Created DTS packages for data migration.

• Database and log backups & restoration, backup strategies, scheduling backups.

• Backing up master & system databases and restoring them when necessary.

• Schedule the jobs for the Database Maintenance.

Environment: Ms SQL server 2000, Windows 2003, MS Access, MS Exchange

Ranbaxy Pharmaceuticals, New Delhi, India Jun 2002 – Aug 2004

SQL Server DBA/Developer

Ranbaxy Laboratories Limited is India’s largest pharmaceutical Company, manufacturing and marketing

world class generics, branded generic pharmaceuticals and active pharmaceutical ingredients. It is ranked

amongst the top ten generic companies worldwide. The project involved Database Administration Support

(Development & Production), Software Installation, Database Performance Tuning & Maintenance,

Database Back up and Recovery, Export/Import of Data, Replication, Creating and Implementing of

various Installs and Database Auditing Analyzing.

Responsibilities:

• Responsible for upgrading and migrating of various applications in Access to SQL Server 7.0.

• SQL Server Administration involving planning and implementing Back up and Recovery Strategies

Analysis of SQL queries and optimizing performance through modifying table design and application

•

code

Configuring the standby servers and setting guidelines to automate recovery scenarios

•

Implementation of data transfer through DTS

•

Setting up and configuring transaction and merge replication of databases

•

Monitoring and fine tuning of SQL Server performance and ensuring integrity

•

Developing triggers and stored procedures to enforce business rules

•

Releasing scripts on the production servers

•

Environment: MS SQL Reporting Services, SQL Server 7.0, MS Access, TSQL, Dotnet, MS Exchange

Server, IIS 5.0/4.0, MTS & Win 2000.

Contact this candidate