Summary:

• Skillful Information Technology DBA with 7 years of demonstrated expertise in installation, configuration, administration and production server maintenance of MS SQL Server 2005/2008R2/2012 database.
• Solid command of database object creation and modifications, backup/recovery, security administration, troubleshooting, performance monitoring and tuning, database propagation, capacity planning, consultation with developers on technical issues, database design, and systems analysis.
• Strengths include administration, database design, performance analysis, and production support for clustered and complex databases.
• Hands on experience includes administering large and complex databases, database design, normalization, replication, log shipping, full text indexing, and database application development using varied development tools. Skillfully use DTS in SQL server, performance tuning, application design, hot and cold backups, disaster recovery planning, security management, managing server and clients, T-SQL, stored procedures, functions, cursors and triggers.
• Experience in implementing different types of Replication Models like Snapshot and Transactional.
• Very good in database modeling including database architecture, physical and logical data modeling.
• Demonstrated history of SQL server integration services support in 2005/2008R2/2012in moving DTS packages.
• Successfully gathered data requirements,designed and fine-tuned databases as per the requirement of clients. Excel in providing complete administration of MS SQL Server 2005/2008R2/2012databases using varied languages including T-SQL, PHP and Pearl.
• Hands on experience working with High Volume Databases.
• Provided Oracle/MS SQL Server DBA support for multiple large databases in production, development and test environments for various types of databases - OLTP and Data warehouse. Wrote highly complex SQL, UNIX shell and PL/SQL scripting involving reviewing and tuning SQL and PL/SQL code, triggers stored procedure to finish the project on time and save the organization cost
• Very good with Performance Monitor, SQL Profiler, Quest Foglight and Quest Spotlight tools to monitor SQL Server Performance and to generate Performance reports.
• Experience in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Well Organized and highly motivated with Excellent interpersonal and communication skills with ability to perform individually as well as in a Team.

Professional Skills:

• Database Management:
• Strong knowledge and working experiences as Database Administrator of MS SQL Server 2000, 2005, 2008, 2012
• SQL Server Upgrade to later version
• SQL Server Database Migration one server to another
• Strong working experience and knowledge with SQL Server Log shipping
• Database Mirroring
• Replication
• Performance Tuning
• Database Backup/Recovery
• Query Optimization
• Security Management
• SQL Server
• SQL Configuration manager
• SQL Server Management Studio SSMS
• Enterprise Manager EM
• Activity Monitor
• Query Editors
• Query Analyzer
• SQL Profiler
• Database Tuning Advisor DTA
• Reporting Services Configuration manager
• Third Party Tools
• Toads for Data Modeling
• Spotlight for Performance Monitoring
• Operating Systems:
• Windows Server 2008, 2008 R2, 2003
• Windows XP Professional
• Windows 7 Professional
• Windows 8
• Programming:
• SQL
• T-SQL
• Trigger
• Functions

Professional Experience:

Confidential

SQL Server DBA

Responsibilities:

• Performs and recommends capacity planning and management of database environments.
• Responsible for the overall configuration management of the database technologies, including database installations, upgrades to new product releases and the installation of service packs.
• Apply patches for Systems and SQL Servers.
• Provide ongoing support for designated applications and databases.
• Experience with SQL Server Upgrade to later version
• Manage the deployment, monitoring, maintenance, development, upgrade, and support of all Database system.
• Monitors and analyzes database performance, producing reports and recommendations for improvements as needed.
• Performs database tuning for diagnosing issues and optimal database performance.
• Manage security procedures for specific user, user applications, access to secure databases.
• Manages backup and recovery of the database, including establishing standards and schedules for database backups, developing recovery procedures for each database and ensuring that the backup schedules meet recovery requirements.
• Designs, develops, monitors and maintains complex database management systems and related components underlying business applications.
• Provide technical direction for Logical/Physical database design, maintenance, and administration.
• Review developer SQL queries and stored procedures for optimization and security purposes
• Used DBCC to check physical and logical consistency of database.
• Working experience with T-SQL, Trigger, Function, Indexes, Constraints, File File Group.
• Implement and Configured Log Shipping from Production to Standby Server Running as Reporting Server
• Experience with ODBC Connection
• Implement and Configured Database Mirroring for High Availability solution.
• Export Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel.
• Write and maintain database and application documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.

Environment: MS SQL Server 2012/2008, T-SQL, MS Access, Excel, MySQL

Confidential

SQL Server DBA

Responsibilities:

• Performed capacity planning for SQL Server Instance Database.
• Installed and Configure SQL Server 2000, 2005 2008R2 in development, test, and production environment
• Experience in Operating System, Windows Server 2000, 2003 2008 .
• Experience with SQL Server Upgrade to later version
• Migrated databases within SQL Servers in test and production environment.
• Identify and address database performance issues and capacity issues.
• Strong experience in operational monitoring and management of databases to ensure maximum uptime and performance, Monitor Servers activity.
• Tune and solve performance problems.
• Experience SQL Server Error Log, space usage, DBCC Command,
• Write T-SQL and Stored-Procedures. Assist SQL developers to optimize SQL queries and Stored Procedures.
• Strong working experience in backup, restore and recovery procedures. Scheduled jobs
• Strong working experience Maintenance Plan.
• Export Import Databases.
• Experience with Data Modeling: Designed Logical Physical Database, Backward Forward Engineering.
• Involved in creating and modifying tables, Index Cluster/Non-Cluster , Constraints, Views, Stored Procedures, Triggers
• Rebuild Servers Restore Recovered from tape/CD backup from backup
• Configured Log Shipping from Production to Standby Server Running as Reporting Server
• Configured Database Mirroring
• Writing documents for Server and databases.

Environment: MS SQL Server 2008R2/2005, Windows server 2008, Microsoft Cluster Service MSCS , T-SQL.

Confidential

SQL Server DBA

Responsibilities:

• Involved in Migration of Production Database Servers from SQL Server 2000 to SQL Server 2005.
• Created jobs and alerts for monthly and weekly maintenance.
• Created Triggers and Maintained Referential Integrity depending on User Requirements and converted them into Technical Specifications.
• Installed SQL Server 2005 SP2 on Test and Production Environment.
• Performed Database Optimization, Performance Monitoring and Index Tuning.
• Performed Implementation of Replication between production Servers.
• Executed various DBCC Commands for checking consistency and system performance fixed data corruption in application databases.
• Daily monitoring of the database performance and network issues using Quest Spotlight Application.
• Implemented Database Mirroring in Development and Production Environment in SQL Server 2005.
• Ensured that SQL Server database jobs are updated accurately and regularly.
• Created various reports using Crystal Reports after performing Data Analysis on the various Data Views available.
• Identified and resolved user login and permission problems.
• Implemented AWE / PAE Switches for SQL Server to grab more than 4 GB RAM.
• Developed and Documented DR procedures and Change Control Processes.
• Created new databases and performed database capacity planning.
• Responsible for Planning and administrating Database Integrity.
• Maintained Version Control of Database Releases.

Environment: Windows Server 2003, MS SQL Server 2000 x64 edition , Microsoft SQL Server 2005, Microsoft Visual Source Safe, Quest Spotlight.