Technical Summary
Six+ years Experience in IT as MS SQL Server 2008/2005/2000 Database Administrator in Microsoft Windows environment. Proficient in designing relational database model and implementation as per business requirements using Erwin and MS-Visio. Experienced in Design, Development, Testing, Implementation and Production, support of System Development Life Cycle (SDLC) in Client/Server and Web Based Application. Extensive knowledge in Installation, Upgrading, Configuration & Maintenance of MS SQL Server, 2008, 2005, 2000, 7.0 on a standalone and Clustered Servers [Active/Passive and Active/Active Cluster Design]. Have extensive work experience in applying latest Service Packs and Hot fixes. Have excellent experience with Database Mirroring, online indexing and recovery. Experienced in optimizing the database by creating various clustered, non-clustered indexes and indexed views. Migration experience from SQL Server 7.0 to SQL server 2000, from SQL Server 2000 to SQL server 2005 and SQL Server 2008. Excellent experience in using SQL Server Configuration Manager and SQL Server Surface Area Configuration. Performed administrative activities like creating User logins with appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups. Good experience with creating alerts, schema management, database reorganization, data loading, database maintenance and optimization. Experience in Database Backup, Recovery and Disaster Recovery procedures. Configured Log shipping to create stand by environment. Worked on Linked and Remote Servers to run queries between SQL server and other data sources using ODBC, OLE DB drivers. In-depth knowledge of Transact-SQL, DDL and DML. Good experience of Creating, Scheduling, Monitoring and Troubleshooting jobs on production environment. Configured and maintained transactional and merge replication on a production environment. Good experience in Debugging Stored Procedures and Triggers and Troubleshooting database issues. Experience in Online Indexing, Query Optimization, Performance Tuning and Database Consistency Checks using DBCC commands. Experience in using Profiler, Activity Monitor and Performance Monitor to resolve Dead Locks, long running queries and slow running servers. Excellent Knowledge of Redundant Array of Independent Disks [RAID] system and Clustering. Installed, configured and maintained Microsoft Reporting Services [MSRS] 2000 and SQL Server Reporting Services [SSRS] 2005. Knowledge in creating and scheduling SSIS/DTS packages in SQL Server in Business Intelligence Development Studio (BIDS) to transfer data in various databases. A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills. Technical Skills
SQL Server Tools: SQL Server Management Studio, Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, SQL Profiler, SSIS and DTS (Import & Export), Replication, Database Tuning Advisor and Index Tuning Wizard, BCP, SQLCMD, Reporting Services Report Manager, Reporting Services Configuration and Report Builder, Upgrade Advisor, SQL Configuration manager and Service manager, Client Network Utility and Server Network Utilities, Surface Area Configuration.
SQL Server Tools : Enterprise Manager, Profiler, DTS (Import & Export),
Query Analyzer, Replication,SSMS,SSIS.
Languages : C, C++, C#, VB.NET, ASP.NET and T-SQL.
Operating Systems : Windows Server 2003, Windows 2000 advanced
Server/professional, WindowsNT/95/98/ME/X, MS DOS
Data Bases : MS-SQL Server 6.5/7.0/2000/2005/2008
MS Access 97/2000/2003
Front End Tools : MS FrontPage 98/2000, MS Office 97/2000/XP,
MS Outlook 97/2000.
Database Tools/IDE : Erwin, Enterprise Architecture
Reporting Tools : MS SQL Server Reporting Services
PROFESSIONAL EXPERIENCE
Confidential,Las Vegas, NV Jan 2010 - May 2011
Global Database Administrator (GDBA)
Working as a Global DBA in the DCC migration project for UHC. DCC (Data Center Consolidation) project is a designed project to migrate previous versions of SQL applications into new MS SQL Server 2008 environment. In DCC project there are more than 13,000 applications that they planned to migrate from US different locations to three data centers i.e. Hartford, Atlanta and Las Vegas data centers.
Responsibilities:
Worked extensively on installation, upgrade and configuration of MS SQL Server 2008 on a Standalone and Cluster Servers as a Single instance and multiple instances. Good experience in Implementation of Production, Integration and Development environment, Hardware requirements and support. Experience with migration of databases from MS SQL server 2005 to MS SQL server 2008 and experience in migration and support of databases for Production, Integration and Development environments (Dedicated & Shared Server). Coordinated and performed quality assurance testing for movement of databases and database objects from development to testing and production environments. Implementation of Point in time Backup and recovery plans of all databases and maintain documentation. Schedule the Administrative Tasks (like database integrity checks and maintenance plans). Migrating DTS Packages into SSIS using Upgrade Advisor and DTS Designer. Creation and maintenance of Users security permissions and migrating the entire database objects from one server to another server. Extensive exposure to creation of databases, objects, stored procedures, triggers, security, DTS (i.e. Import and Export), Transact-SQL experience, and SQL Server Agent and SQL Server profiler. Creation and scheduling of Maintenance plans (database and log backups and cleanups) Implemented disaster recovery for SQL Server Production Database as Fail-Over and/or Standby servers. Used Log Shipping Technique for warm backup solution for MS SQL Server databases. Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues. Good experience on configuring Replication, mirroring, and Log Shipping in SQL Server 2008. Environment: Windows 2000 Advanced Server/Server 2003, SQL Server 2005-2008, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, Upgrade Advisor, DTS Designer Tools, Windows Performance Monitor.
Confidential,Somerset, NJ April 2008 – Dec 2009
Database Administrator
Performed all Database Administrative tasks. Migrate current version of SQL Server 2000 to 2005, handled database objects using Query Analyzer, Created logins with appropriate roles. Backup and Restore databases using traditional backup recovery solution, configured Log Shipping for production server and Replication.
Responsibilities:
Installation of MS SQL enterprise servers on test, development and production boxes on a Stand by and Clustered servers. Performed Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments. Handling database objects with Enterprise Manager and Query Analyzer. Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups. Creating Proper Views to prevent unauthorized access and have extensive Transact SQL experience. Database Backups & Restoration, Backup Strategies and Scheduling Backups. Tested backup and recovery strategies in a test environment and verify the validity of tape backup. Coordinated and performed quality assurance testing for movement of database and objects from development to testing and production environments. Configured Log Shipping to create a stand by server for production server. Worked on migration and maintenance of data using various utilities like DTS, IMPORT/EXPORT and ATTACH/DETACH Data Migration. Created and Maintained Snapshot, Transactional and Merge Replication. Responsible for query optimization, performance tuning and index tuning. Designed and Developed reports by using SQL Server 2000/2005 reporting service. Environment: Windows 2000 Advanced Server, MS SQL Server 2000/2005, Microsoft Reporting Services (SSRS), MS Outlook, TSQL, ERwin etc.
Confidential,Baroda, INDIA Sep 2006 - Feb 2008
MS SQL Server 2000 DBA
After conducting a detailed assessment to evaluate the effectiveness of our clients’ current technologies and determine their specific needs, Icon Software Technologies will provide them with detailed information about how clients business can use technology to cut costs and increase productivity.From initial assessment to implementation and ongoing support, Icon provide strategic consulting for every phase of the process.
Responsibilities:
Worked on SQL Server 2000, which is installed on a cluster (Active/Passive) environment with fast problem solving capacity. Created logical and physical data modeling for development database using ERwin Tool. Installed MS SQL Server, Performed Database Design and created User Databases Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best. Scheduled backups and performed restore operations for system test data depending on developers’ requirement. Involved in disaster recovery procedures for production servers. Created DTS Packages to upload test data from Text files. Performed Data migration (import & export) from Text to SQL Server and data transfer using BCP and DTS. Managed Disk space, memory and User connections. Perform T-SQL tuning and optimizing queries. Performed query plans and made sure each and every query is using appropriate indexes by using Profiler. Responsible for Stored Procedures optimization, Performance tuning & index tuning. Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing. Used DBCC checks and fixed data corruption in Application databases Responsible for capacity planning, monitoring Disk I/O, CPU and memory. Maintained and created replications (Transactional and Snapshot). Environment: MS SQL Server 2000, Windows 2003 Server, Windows 2000 Advanced Server and ERwin.
Confidential,Anand, INDIA Dec 2004 - Aug 2006
Database Administrator (DBA)
Confidential,is a multi-modal IT agency in one of the fastest growing areas of the country, responsible for planning, building and operating a highway system in addition to operating a large manufacturing.
Responsibilities:
Upgrade experience of SQL Server 7.0 to 2000. Experience in applying Service Packs at database and OS Level. Created & maintained databases, table spaces, users, tables, indexes, store procedures, roles, profiles, partitions and other schema objects. Performed backups, DBCC utilities, updated index statistics, monitored database and disk space. Involved in security issues and scheduled tasks. Configured Log Shipping to create a stand by server for production server. Worked on migration and maintenance of data using various utilities like DTS, EXPORT, IMPORT and ATTACH/DETACH Data Migration tools. Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents. Monitored the excessive fragmentation of Indexes and took remedial steps. Created the maintenance plan for optimization and integrity check for all SQL servers. Involved in maintaining of Stored Procedures, Functions and DTS Packages, enforced database triggers for auditing. Monitored Databases for Lock Escalation, Dead Lock, resource utilization by sessions, Capturing long running SQL queries, used HINTS for fine-tuning SQL statements that better result in efficient SQL statements processing. Developed forms and generated reports in Access, as requested by the staff. Environment: MS SQL Server 2000, Windows 2000 Advanced Server and Erwin.
EDUCATION
M.Sc. in Computer Science
B.E in Information Technology
Privacy Policy
