SUMMARY

• Database Administrator having experience of about 7 years in IT with extensive exposure in Administration of MSSQL, ORACLE and SYBASE, an innovative, result oriented techno functional professional with visible achievements in the area of Production Database Administration. With my technical and analytical skills coupled with hard work, I have the right focus and determination to seek and establish a professional career with an esteemed organization in a challenging position that suits my skills, abilities, professional knowledge and specialized experience.
• 7+ years of IT experience in Database Administration, Design Development and Support of MS SQL Server 2016/2014/2012/2008 R2/2005 in Production, Test and Development Server Environments.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2016/2014/2012/2008 .
• Experience in upgrading SQL Server from version /2012 and /2014/2016.
• Design and Implement Database Backup Restore & Disaster Recovery Strategy.
• Good experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping and alwaysOn availability groups.
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Created maintenance plans to perform index de - fragmentation, re-indexing and update the index statistics.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, Performance Monitor, SQL Profiler, index tuning wizard.
• Experience in applying patches and service packs to keep the database at current patch level.
• Installing & Configuring SQL Server Analysis Services.
• Memory Management for SQL Server Analysis Services.
• Experience in creating linked servers to various data sources (SQL Server, Oracle and Sybase).
• Cube Deployment using BIDS.
• Database Backup Restore Strategy design and Implementations for OLAP Databases.
• Installing and Configuring Integration Services.
• Deployed and Scheduled DTS.
• Installing and Configuring Reporting Services.
• Oracle 11g & 12C Database Administration.
• Experience in Oracle Database Backup & Recovery.
• Experience in managing table spaces, data files, redo logs, tables and its segments.
• Experience in managing Users, Privileges and Roles.
• Experienced with Sybase IQ database 15.7.
• Automated the dump and load of databases using shell scripting.
• Managing security which includes creating logins, users, groups, assigning users to groups, granting and revoking right/privileges, assigning appropriate roles and fixing login-user mismatches.
• Installing Sybase clients on user machines and configuring ODBC settings to the databases.

TECHNICAL SKILLS

Database: Microsoft SQL Server 2005, 2008, 2008R2, 2012 and 2014 Oracle 11g and 12C Sybase ASE 15.7

Operating System: Windows Server 2003, 2008 and 2012

Tools: Management Studio, Visual Studio 2010, ProfilerDatabase Tuning Wizard, Replication MonitorRapid SQL, SQL plus, SQL DeveloperDB Artisan, Sybase Central, ISQL.

Software: PLSQL, C

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential -CT

Responsibilities:

• Performed installation of SQL Server 2008/2012/2014 and 2016 in Development, Production and UAT environments.
• Performed upgrade from SQL Server 2005 and 2008/2008R2 to SQL Server 2012/2014 and 2016.
• Installed services packs on SQL server to keep the database at current patch level.
• SQL Server Hardening & Best Practice Implemented.
• Created both Snapshot and Transactional replication.
• Involved in SQL Server Always on availability groups configuration POC.
• Created Linked servers on SQL Servers pointing to Oracle and Sybase database.
• Performed Backup/Restore to/from EMC data domain tools.
• Checking Database Health by using DBCC Commands and DMVS.
• Worked on granting permissions to database, cubes and SSIS packages.
• Daily routine DBA tasks like space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
• Implemented Data Quality and Master Data Service.
• Performed SSAS cubes backup and restores.
• Worked on cubes permissions.
• Deployed SSIS packages and granted permissions.
• Installed and configured reporting services.
• Creating ODBC connections on user machines to different database.
• Perform CORE DBA tasks such as Database Administration on Oracle 10g, 11g and 12C environments, performance tuning, Schema creation, maintenance, and troubleshooting.
• Implement physical database changes, testing, and performance tuning.
• Plan and Design Backup/Recovery solutions using shell scripts and Import/Export.
• Experienced in creating users and roles.
• Handled database server tuning, application tuning, maintaining documentation and capacity planning.
• Support a production system setup comprising of Sybase 15.7.
• Monitor Crontab jobs daily and rectify issues if any.
• Automated the dump and load of databases using shell scripting.
• Creating physical Devices and Databases.
• Creating user logins and adding users to databases aliases and allotting roles to users.
• Managing security using grants and revokes, Performing Backup and Recovery of Databases.
• Worked on direct connect tool which connects Sybase and DB2 databases.
• 24 X 7 Production Database on Call Support.

Confidential

Junior Database administrator

Responsibilities:

• Involved in installation and configuration of SQL server 2008/2008R2.
• Applied patches and service packs
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Setting up database recovery models as per the requirement.
• Worked on backup and restore activates.
• Management of users including creation/alteration, grant of system/dB roles and permissions on various database objects.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification, replication verification, and indexing updates.
• Hands on experience in troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Involved in resolving locking and blocking issues.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Deployed and scheduled SSIS package.
• Configuring ODBC settings on user machines.
• Worked on System Centre Operations Manager(SCOM) tool for database monitoring.
• Provided 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments.