SUMMARY

• 8+Years of Experience as a SQL SERVER DBA in Implementation, Administration, Database Design, Development & Support of SQL Servers 2000, 2005, 2008 and 2012 in Production, Test, and Development Environments
• Experience in replication, log shipping and SQL Server Failover Clustering.
• Experience in setting up, troubleshooting and maintenance of production server databases.
• Performed In - Place and Side-by-Side Migration between instances of SQL Server 2000, 2005 and SQL Server 2008.
• Sound knowledge on Operation CIRT Handling.
• Familiar with VERITAS Cluster. Monitoring the Nodes and Volumes.
• Responsible for reviewing and deploying any production changes through Release for change (RFC) process
• Responsible for interacting with other technical support groups to determine appropriate disk platforms, disk configuration, operating system kernel settings and database engine configurations.
• Familiar with the ITIL standards and implementations.
• Well versed with project responsibilities such as planning and implementation i.e., Migration and Up-gradation.
• Proficient in meeting tight deadlines and adopting new technologies.
• Experience in using Service Desk application, used to assign/track/document all requests for work impacting the nature.
• Monitoring the servers by accessing remotely and analysing the databases.
• Experience in Active directory user management, replication and monitoring.
• Experience in handling Production Servers having an average 120 user Databases in each server spread across various locations.
• Very Good experience on Optimising Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Installation, configuration and maintenance of MS SQL Server.
• Checking the status of Backup troubleshooting the failed backups and Restoration of databases.
• Experience in Performance Monitoring, Performance Tuning and Security Administration by implementing Schemas, Optimizing queries, Tuning indexes and DBCC using DBCC Utilities.
• Adding users in the database and granting permissions.
• Scheduling jobs in SQL Server.
• Recovery of the database during crash or data Loss.
• Coordinating with the development and test teams in the Implementation and Maintenance of projects.
• Handling various issues rose from the users regarding the data entry errors in the database. SQL2005 and configuring services.
• Proficient in Designing and Documentation of SQL Server Strategies and plans.
• Experience in Documenting all Database Architecture according to established standards.
• Worked as a single DBA and worked in a Team of DBA’s in projects so far.
• Analytical and highly versatile, team-oriented individual. Skillful in translating strategy into actions by organizing tasks, building and sustaining relationships and leading team members through project inception to completion under strict time and resource constraints.
• Familiar with ENDUR application and standards of trading.

TECHNICAL SKILLS

Programming Languages: Transact SQL, C, C++, Java, Microsoft Active Server Pages (ASP), PL/SQL, Shell scripting

Web technologies: JavaScript, HTML/ XML

Databases: MS SQL Server 2000/2005/2008 and 2012, MS-Access, Oracle 10g

Operating Systems: Windows Family, MS DOS, UNIX, Linux.

SQL Server tools: Management Studio, Enterprise Manager, SQL Profiler, Query Analyzer, System Performance Monitor, Export & Import, Replication, SQL Litespeed

PROFESSIONAL EXPERIENCE

Confidential

SR. SQL SERVER DBA

Responsibilities:

• Work closely with Client’s Technical team, Front Office and Middle Office users for technical solutions of business requirements.
• Responsible for the daily trade flow process and ensure all the operations are going on smoothly, without any interruption
• Installation and maintenance of Production boxes which has Endur application, Oracle and SQL Server.
• Performing the health check of the Production servers.
• Deploying the Java, Java Script, J2EE, ASP and XML production changes through Release for change (RFC) process.
• Research, Analyze and troubleshoot technical issues.
• Configuring the PROD, UAT and QA environments.
• User Management through Oracle for Endur application
• Configuring and maintaining ICE Gateways.
• Monitoring SQL server databases
• Enhancements and implementations of new solutions.
• Perform backup and restore of database as per the user requirements.
• Manage offshore team being in Charlotte, NC.

Environment: MS SQL Server 2008, Oracle 10g, Endur (OpenLink), Weblogic (Java, J2EE), C++, Java Scripting, Shell Scripting, XML, Microsoft Active Server Pages (ASP) and Grid Server

Confidential, TN

Sr. SQL Server Administrator

Responsibilities:

• Installation and maintenance of SQL Server software on production/development / Quality Assurance
• Servers and clients
• Monitoring SQL server databases
• Handling Very Large databases ranging in sizes from 500 GB to 1.3 TB
• Provided L2/L3 support as the primary point of contact for all technical and operational issues
• On call support
• Tuning data & performance of the servers, and working with development teams to identify & suggest Optimization enhancements
• Implementing Database Replication for VLDBs
• Maintain integrity and consistency of the databases.
• Deploying custom maintenance procedures to maintain the health of large databases
• Implementing Log shipping and Database Replication for high availability of 24x7 active databases
• Experience in Installing and Configuring Failover Clustering for high availability in Active/Passive.
• Configured and monitored Database Mirroring.
• Worked extensively on Database space management, performance monitoring and alert management.
• Coordinated with back-end programmers in optimized stored procedures, Tuned Stored Procedures and carried performance improvement on long running queries and used DTA.
• Analyzed Traces from the SQL Profiler to troubleshoot database and used DBCC consistency checks for other database maintenance aspects.
• Designed & implemented databases, tables, views, clustered and non clustered indexes in production environment.
• Administered the 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.
• Worked on replication latency and distribute the over load on publisher servers. Created 3 new distribution server by own and reduced the over load on the server.
• Prepare steady state documentation and cutover scripts for the entire SQL processes at PCA.

Environment: SQL Server 2000, 2005, 2008 R2 (32 and 64 bit) and 2012, Windows Server 2000/2003(32 and 64 bit), SSMS, SSIS, SSRS, Enterprise Manager, T-SQL, Log shipping, Replication, Clustering, SQL Profiler, Performance Monitor. C++, Microsoft Active Server Pages (ASP) and Java Scripting

Confidential, TN

Sr. SQL Server Database Administrator

Responsibilities:

• Migrated data from SQL server 2000 to SQL server 2008
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Managing SQL databases, Security, fine tuning of SQL queries, troubleshooting
• Designed technical specifications and implemented business components for the site using C++, Java, JavaScript, Microsoft Active Server Pages (ASP), DHTML, HTML, XML
• Created transactional replication on different servers.
• Worked on UNIX/ LINUX, MS SQL Server, Oracle server and Windows servers extensively
• Developing SQL stored procedures, views and triggers.
• Installation and configuration of SQL Server components
• Regular overview on the performance of Database queries using Profiler and Event Viewer graphs.
• Configured Log shipping for the disaster recovery plan in SQL server2005.
• Check SQL Server jobs (look for failures) and the SQL Server logs for error messages
• Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities
• Managing Logins, Users, Roles and User permissions.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance.
• Responsible to releases from development to test to production environments

Environment: SQL Server 2000, 2005 and 2008, Windows Server 2003, Enterprise Manager, SSMS, Query Analyzer, SSIS, SSRS. T-SQL, C++, Microsoft Active Server Pages (ASP), Java Scripting

Confidential, TN

SQL Server Database Administrator

Responsibilities:

• Building SQL Servers to create and deploy new databases
• Handling backup process, writing the automated jobs for taking the weekly full backup, daily differential backups and hourly transactional backups
• Performing the ETL operations to support the data loads and Transformations.
• Created and maintained the knowledge base system for all the application databases
• Implemented automated backup and database maintenance / cleanup jobs
• Create backup and recovery plans using 3rd party backup tools such as Quest LiteSpeed
• Imported Data from text files and excel spread sheet into SQL Server 2000 database using DTS package.
• Managing Logins, Users, Roles and User permissions.
• Installation of SQL server 2005 on Development and Production Servers, setting up databases, users, roles and permissions.
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Making required schema changes
• Implemented log-shipping and transaction replication in DR process plan.
• Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks
• Had good experience in 24/7-production support.

Environment: MS SQL Server 2005, Windows 2000, Windows NT 4.0, SSMS. SQL profiler, Performance Monitor, MS Active Server Pages (ASP), Java Scripting

Confidential

SQL Server Database Administrator

Responsibilities:

• Maintaining the production database servers.
• Monitoring the growth of the database to ensure the smooth running of daily activities.
• Taking full / differential database backups of all system and production databases.
• Taking back up of system databases whenever changes are made to the system databases or updates and service packs are applied to the SQL Server
• Check the Windows 2000 Event Viewer for error messages.
• Check for adequate disk space for growing database files and log files.
• Check SQL Server jobs (look for failures) and the SQL Server logs for error messages.
• Controlling and monitoring user access to the database
• Import and Export data from one database to another database or to another server using DTS
• Remove extra-unused space from the data and log files
• Evaluate possible approaches to increasing application and server performance, based on the knowledge obtained from daily operational activities
• Requirement gathering and analyzing data sources
• Assisted in design and implementation of Database
• Installation and configuration of SQL Server 2000 and 2005
• Design and implementation of Backup policies and Recovery procedures
• Created stored procedures and triggers

Environment: SQL Server 2000 and 2005, Windows 2003, T-SQL, XML, Java Scripting, Visual Basic and Microsoft Active Server Pages (ASP)