Professional Summary:
Over 7 Years of professional experience in Administration, System Analysis, Design, Production, Test, Development, Replication and Cluster Server Environments, Development and Support of MS SQL Server 2008 R2/2005/2000. Experience in Database Administration activities like Installation, Configuration, Migration, High Availability Solutions, Database Security, Database design and Query optimization. Proficiency in working with high transaction OLTP systems in SQL Server 2008 R2/2008/2005/2000. Experience in upgradation & Migration from MS SQL Server 2000 to MS SQL Server 2005 and MS SQL Server 2005 to MS SQL Server 2008. Experience in using SQL Server Profiler, Windows Performance Monitor for Performance Tuning and Query Optimization, database consistency checks using DBCC utilities and DMVs. Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005 databases. Expertise in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster. Experience in using data modeling tools like SQL Diagrams, Erwin 7.1 & Microsoft Visio 2003 and worked with third Party Backup solutions like SQL Lite speed for MS SQL Server. Expert in implementing different types of Replication models like Snapshot, Merge and Transactional. Proficiency in capacity planning, performance tuning, disaster recovery, troubleshooting, backup and restore procedures. Extensive knowledge in Tuning SQL queries & improving the performance of the Database and experience in writing and debugging Stored Procedures, Triggers using T-SQL. Creation and maintenance of Databases, creating Roles and managing user permissions and resolving Blocking and Dead lock Issues by using SQL commands. Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors. Experience in providing 24x7 Production Support and On-Call rotation. Fast learning capability, problem solving and conceptual skills, ability to work effectively in a team environment. Education Qualification:
International Masters of Business Administration
Skill Set:
MS SQL Server 2008 R2/2008/ 2005/ 2000, T-SQL, DB2, Oracle, MS-Access, Query Analyzer, SQL Profiler , SQL Agent, SSIS, SSAS, SSRS, Windows 98/2000/ XP /2003 Server , DTS, Quest Spotlight, Lite Speed , Visual Source Safe , Erwin , Visio 2007 , C , C++, RAID, Database Tuning Advisor, Database Mail, Diagnostic Manager, Crystal Reports 10.
Project Summary:
Confidential,Carlstadt, NJ 4/2010 - Present
MS SQL Server DBA
Confidential,to be the leading brand of quality lifestyle accessories offering classic, modern American styling. The project goal was to migrate SQL Server 2005 to 2008, upgrading their existing environment, providing high availability solutions on production databases. It also aimed at setting up transactional replication between its primary and read only server.
Responsibilities:
Migration of SQL Server 2005 to 2008 . Worked closely with application owner, manager and other DBA for planning and implementation of the migration. Successfully upgraded of SQL Server 2005 to SQL Server 2008 on DEV, QA and Production Environment. Responsibility included configuring, administration and troubleshooting multiple databases including VLDB in development, QA and Production environments in clustered and stand-alone environments. Verify, maintain and created automated procedure for daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing updates and compression of databases. Implemented Log Shipping, with SQL Server 2008 successfully and extensively involved in setting up Database Mirroring for high availability. Support and maintenance of Transactional Replication between Primary Servers and Read-Only servers, with separate Distributor server and experience in troubleshooting replication problems. Assigned permissions to user(s), role(s), and object. Support column level permission. Administrate security for servers logins (Windows and SQL Accounts). Experience in connecting to remote SQL Server as Linked Servers and support Development Team in deploying and testing the application, which uses SQL Server backend. Used third party backup tool like SQL lite speed to improve performance of backup and recovery and resolving issues through Performance Monitor, Quest Spotlight to monitor the counters. Responsible for providing daily and weekly reports to the immediate supervisor and actively involved in the daily and weekly meeting to discuss project status. Environment: MS SQL Server 2008, MS SQL Server 2005, MS Access, Windows 2003 Server Enterprise Edition, Windows 2000 Server, IIS Server, Visual Studio .NET, Dell Power Edge , Quest Spotlight, Lite Speed.
Confidential,New York, NY 11/2008 - 3/2010
SQL Server DBA
Confidential,is a market-leading global information services and publishing company .The scope of the project was to maintain the Production, Test, and Development and cluster Server Environments. It also provided support for developers in developing SQL queries.
Responsibilities:
Backing up, restore system and other databases as per requirements, Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them. Creating new database/tables to put in the extracted data and rebuilding the relationship and optimized various slow running queries by monitoring System Monitor. Involved in gathering user Requirements, application design, and analysis of hardware requirements to meet business needs. Designed ER diagrams, logical model candidate keys and physical database as per business requirements using Erwin tool. Provided production support for the ETL jobs and also to the code deployed into the production environment and working as a team member with other DBA’s to support all corporate databases. Managing security, which includes monitoring and controlling database access, assigning permissions to application owners and maintained the consistency of the clients Database using DBCC. Developed various T- SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction. Configured and maintained transactional and merge replication for 2 environments. Involved in SQL Server disaster recovery procedures. Responsible for Stored Procedures optimization, Performance tuning & index tuning. Monitoring the server using SQL Lite Speed Backup tools and have a good experience in SQL Server Managers SQL Server Agent jobs. Environment: MS SQL Server 2000/2005, DTS, T-SQL, Windows 2003 Server, Erwin, Business Intelligence SSIS, SSAS, SSRS, SQL Agent, SQL Profiler, RAID, Database Tuning Advisor, Database Mail, Lite Speed.
Confidential,Houston, TX 5/2007 – 10/2008
SQL Server DBA
Confidential,is a technology company that provides infrastructure and business offerings that span from handheld devices to some of the world\'s most powerful supercomputer installations. The scope of the project was to setup and maintenance the databases, conducting database performance monitoring and tuning, controlling and monitoring user and applications access to the database.
Responsibilities:
Create new databases, tables, and fields for data entry, performing database capacity planning. Identify and resolve user login and permission problems and use version control tools. Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitored connections, locks and performance of SQL server. Tested and installed SQL Server 2005 and migrated DTS packages from SQL Server 2000 to SQL Server 2005 IntegrationServices (SSIS). Database optimization, performance monitoring, index tuning and creating jobs and alerts for monthly and weekly maintenance of SQL server. Used SQL Server 2005 Management Studio (SSMS) to develop, deploy and troubleshoot databases. Ensure that SQL Server databases are updated accurately and regularly. Implement Log shipping between production and DR servers. Analyzing and administering the best Synchronization mechanism and utilities required for each environment. Tested and implemented Database Mirroring solution for Production critical application and implemented transactional replication for populating reporting database. Develop and Document DR procedures and Change Control procedures and plan and administer database integrity. Assist development staff with application design Available for working in 24x7 production environment. Environment: Windows 2000 Advanced Server, Windows Server 2003 EE, MS SQL Server 2000, Microsoft SQL Server 2005,Microsoft Visual SourceSafe 6.0.
Confidential,Linden, NJ 1/2006 – 4/2007
SQLServerDBA
Confidential,is a national provider of wireless voice, messaging, and data services. The aim of the project was to support development team in staging, testing, and production, installing SQL Server and configuration, creating new database objects, and migration of databases.
Responsibilities:
Installed and configured new SQL server instances. Monitored Backups are successful in DEV, TEST and PROD environments. Administer SQL servers located within T-Mobile data center and specific servers within the regional offices and other entities. SQL Server 2005/2000 Clustered Resources and Single Server Instances. Provided Backup/Restore Solution Support for all SQL Instances. Assisted application owners with DB design and provided the Service Desk with information required to support on-going requests. Performed Database Backups and Restores and Involved in Trouble shooting and resolved Backup solution issues. Install and configure SQL server and related monitoring tools and provided problem determination and resolution support for SQL server related application problems. Worked collaboratively with development staff toward resolution, provided advanced tuning expertise. Provided support for system management and monitoring tools and Implemented 3rd party client connectivity software (Oracle Client). Installation and configuration support for Compliance Manager, Diagnostic Manager, and MS Operations Manager and responded to all non-critical system alerts in a timely manner . Environment: SQL Server 2005/2000, T-SQL, Management Studio, Integration Services/DTS, BCP, Bulk Insert, Bulk Load, Analysis Services, SQL, XML, Erwin, Visio.
Confidential,India 8/2004 – 12/2005
SQL Server DBA/ SQL Developer
Confidential,the largest state owned banking and financial services bank. The scope of the project was to create Customer Credit information system in which a whole new database system to report the information of various customer accounts and maintenance of customer information for the purpose of making decisions, such as loan approvals etc.
Responsibilities:
Create and maintain various databases for Production, Development and testing using SQL Server 2000. Planning the location of data, index, and Transaction log files on the disk. Install Database Management Software for SQL Server on the server and client machines, provide connections and manage databases. Resolving locking and blocking issues. Tuning the Production Server to get the performance improvement. Reviewed third party tools so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs. Implemented backup and database maintenance plans and monitoring SQL Server logs, Application logs and analyzing the logs. Creating operators and alerts in getting notifications and creating users and assigning permissions in the DEV box. Planned and modified the permission issues in the server. Running Index Tuning Wizard, implementing Log Shipping, Monitoring and troubleshooting performance. Creating backup strategies and scheduling them for execution. Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running. Providing 24x7 supports to SQL application developers in implementing the applications on production server. Environment: MS SQL Server 2000, Windows 2000 Advanced Server/NT, IIS Server 5.0, Diagnostic Manager, Reporting Services, XML, Crystal Reports 10, Visual Studio.
Privacy Policy
