SQL DBA

Location:

Princeton, NJ, 08540

Salary:

C2C(Negotiable)

Posted:

June 20, 2008

Contact this candidate

Resume:

Nitesh Bairagi

• * Years plus of experience in development and administration SQL Server.

• Hands on experience in installing, configuring, administering, monitoring and troubleshooting SQL Server 2000/2005.

• Extensive experience in Database Programming.

• Table Normalization, Optimization and Tuning, Data Import/Export, Troubleshooting, Database Objects authorization, DTS, SSIS, Objects creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors and Triggers.

• Intensive experience in monitoring, optimizing and tuning SQL database server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.

• Well versed with Object Oriented Analysis and Design, Client/Server architecture, relational databases and writing business logic both at front-end and at back-end.

• Expert in automating process by creating Jobs, and error reporting using Alerts, SQL Mail Agent.

• Experience in designing Backup, Restore, Log shipping and Replication for production databases.

• Experience in complete Software Development Life Cycle (SDLC) including conception, analysis, designing, development and deployment.

• Installed, configured and maintained fail over clusters in production environment.

• Experienced in Data migration.

• Experienced in DTS development.

Technical Skills:

 RDBMS/DBMS: SQL Server 2000/2005, MS Access

 Database Tools: SQL Server Enterprise Manager, Management Studio,

Microsoft Management Console,

Query Analyzer, DTS Designer, SQL Profiler

 Operating Systems: Windows NT/XP/2000/2003

 Languages: Visual Basic 6.0, VB .Net 2003,

 Tools: MS-Office, Visio, MS Visual Studios,

 Scripting Languages: ASP, VB Script, JavaScript, HTML, DHTML

 Reporting Tools: Crystal Report

 Web Server: IIS 6.0

Education:

 Bachelor of Computer Applications (B.C.A.) (3 years full time degree) from M.M.Y.V.V, India.

Diploma in Advance Computing (DAC) (6 months Post Graduate Diploma) from C-DAC, Advance Computing Training School, Pune, India.

Professional Experience

Project Name: IR-DBA Dec-07 to Till Date

Environment: SQL Server 2000/2005

Client: Consolidated Edison Company of New York (Con Edison), a regulated utility, provides electric service and natural GAS in New York City. Con Edison is a subsidiary of Consolidated Edison, Inc., one of the nation’s largest investor-owned energy companies, with approximately $13 billion in annual revenues and $29 billion in assets

Description: Information Resources-DBA team is responsible for installation, configuration and management of all Database Systems in the company.

Role: SQL Server DBA

 Installation& Configuration of SQL Server 2005/2000 server on test and production environments

 Creation and configuration of SQL Databases including striping VLDB’s (200GB) across multiple files and file groups(Datafiles,Logfiles,Indexfiles,tempdb)

 Security Administration (adding logins, DBusers, granting permissions thru roles, managing Schemas) on the SQL Server

 Creation&Migration of various DB Objects like Tables, Primary Keys,Foreign Keys,Indexes,StoredProcedures,functions across multiple environments

 Implementation of Backup and Recovery methodologies involving Full and Tranlog backups across Production, UAT and Development servers

 Involved in the development of SSIS packages

 Involved in programming stored procedures and created DTS packages using MS SQL Server to perform data cleansing and to replicate data to the remote database server

 Involved in creating LinkedServers across between SQLServers and across other heterogeneous data sources like Oracle, MS-Access,ADSI (Active Directory services)

 Involved in monitoring Transaction Logs and DB Growth and attending space issues

 Monitoring Blockings and Proactively monitor Deadlocks and resolve them by setting up trace flags –T1204,1205,-T1222 as startup parameters

 Involved in Defragmentation & Perf tuning using DBCCShowcontig,REINDEX,INDEX DEFRAG, Update Statistics

 Involved in Perf tuning activities for Hardware,Server,Database and QUERY Optimization techniques

 Involved in Bug fixes , Documentation and support

 Working with various Development/User team to resolve and test all ongoing/new issues

 Interacting with Windows OS, SAN, Security and Monitoring areas to setup procedures for SQL Server 2005 installation, storage, backup and recovery and security.

 Implemented migration of SQL Server 2000 to SQL Server 2005.

 Involved in 24*7 Production support

 Installation of Servicepacks,hotfixes and rollout to all environments methodically

Project Name: Global SQL Database Administration Jun-05 to Nov-07

Environment: SQL Server 2000/2005

Client: JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $1.4 trillion and operations in more than 50 countries. The firm is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity

Description: Global SQL database administration team is responsible for installation, configuration and management of all Database Systems in the company.

Role: SQL Server DBA

 Installing and configuring SQL Server 2000/2005 with required Service Packs and patches as required by the client.

 Monitoring the database backup, drive space, log space, for all production servers on regular basis.

 Building and Monitoring log shipping and Replication.

 24x7 production support and on call DBA.

 Managing user permissions.

 Migration from SQL 2000 to SQL 2005.

 Performance tuning of slow performing queries/SPs.

 Run DBCC checks, rebuild indexes, and update statistics for databases.

 Scripting Jobs in native as well SQL Litespeed.

C.T.D.B.S. Feb-04 to Jun-05

Environment: Windows 2000/XP, MS SQL Server 2000/2005, SQL Query Analyzer, SQL Enterprise

Client: Countrywide Financial Corp,

Description: America’s number 1 mortgage company and the world's one of the most valued financial company to customers, colleagues, investors, business partners, and the communities. Positioned under 150 in Fortune 500 and headquartered in Calabasas, California, USA.

Corporate Technology Database Services team maintains and monitors data warehouse. It monitors all the projects running at Countrywide with their different life cycle stages through an internal tool known as FASTER. Databases and Server performances are closely monitored and logged through automated scripts rather than SQL Enterprise Manager.

Role: SQL Developer/DBA

 Set up & Configure database servers for multiple environments (Development, Test & Production)

 Design tables, Implement relationships(Primary/Foreign Key) & forward engineer across all the environments based on application requirements

 Involved in Creation of DB objects like Indexes, Stored procedures & triggers using T-SQL and maintain them

 Created Logins, users & roles and involved in Daily User Maintenance

 Involved in programming stored procedures and created DTS packages using MS SQL Server to perform data cleansing and to replicate data to the remote database server

 Created Linked Servers across Other SQL Servers and MS Access and uploaded data using the Link servers

 Created Database Maintenance jobs to perform Full ,differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler

 Set up Transactional Replication between servers and troubleshoot the issues

 Monitor database growth activities & Troubleshoot Transaction Log Issues

 Scheduled weekly Reindex & other Database Maintenance Jobs to check database consistencies

 Maintaining four corporate web sites. Tasks include server migration, troubleshooting web application Connectivity issues, monitoring availability and performance, and support deployment of new enhancements

Project name: “EARNS 1.0” Oct-03 to Feb-04

Environment: MS SQL Server 2000, SQL Query Analyzer, SQL Enterprise

Client: N.H.P.C, Spectranet Pvt Ltd

Location: India

Description: The project developed for the employee’s administration including

Their attendance, leaves, conveyance, tour advances and payments,

Temporary and permanent advances against salary, medical claims

Role: SQL Developer/DBA

 Installation, Creation, Administration and Maintenance of SQL Server Databases (Production / Development / test)

 Maintenance of Production and Development Servers, ensure the availability of the production databases to end-users and development database to developers in a 24x7 environment.

 Troubleshooting database related problems as and when required and data loading / migration.

 Build, configure, monitor and troubleshoot database instances and database servers.

 Establish and Maintain Backup & Recovery policies and procedures.

 Implement, audit and maintain database security (create and maintain user and roles, assign privileges).

 Optimized code and performance, Transaction Management, Creation of scheduled jobs for purging the Data

 Wrote Scripts for automated database refreshes, automated backups, startup, shutdown or regular monitoring of databases.

 Perform code review on SQL and related code as needed.

 Act as a liaison to development teams to advice on database standards and best practices.

 Perform production SQL release final verification procedure to production.

 Document all database changes and follow and enforce change and release management processes

 Involved in T-SQL Programming for writing both database and business stored procedures

 Migrated Code across different environments

Project name: “PFM SYSTEM” Sep-02 to Oct-03

Environment: MS SQL Server 2000, SQL Query Analyzer, SQL Enterprise

Client: M.T.N.L, APPLO

Description: This application does all the processing of various type of provident fund trust. The client is maintaining the provident fund trust for various other clients. Their basic aim to make all the processing related to provident fund trust like processing of Loan application, Settlement application and Transfer of their account online.

Role: - SQL Developer/DBA