RAJESWARI

E-Mail:adkj5m@r.postjobfree.com

Contact info: +1-860-***-****

Professional Summary:

I have been in the IT industry since 9+ years and am a Microsoft SQL Server database administrator. I have good experience in administration of MS SQL Server 2000, SQL Server 2005, SQL Server 2008,SQL Server 2008R2,SQL 2012,SQL 2014 .

Have configured and implemented on different database platforms like SQL server 2005/2008/2008R2/2012/2014.

Experience in Database Backup, Recovery and Disaster Recovery procedures.

Expertise in planning and implementing MSSQL server security and database permissions.

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

Hands on experience in trouble shooting database issues.

Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS).

Monitoring disk space utilizations,T-Log file size maintenance, and capacity planning.

Creating Maintenance plans and troubleshooting SQL Server Agent Scheduled jobs like Backup, Integrity, Optimization, and Log Shipping jobs regularly.

Maintenance and Implementation of high availability solutions with Log –Shipping and Mirroring.

Have hands on experience in Transactional Replication and Database Mirroring.

Have proficient skills in backups and restore mechanisms for SQL databases.

Have conceptual knowledge of memory management and operating system concepts involved in configuring SQL server database.

Have hands on experience in Always On and 8 nodes Clustering features.

TECHNICAL SKILLS:

Data bases :Sql Server 2000/2005/2008/2008R2/2012/2014.

Operating systems: Windows XP/ NT, Windows 2003.

Working Experience:

Worked as a Core DBA in Wipro Technologies from Apr 2010 to June 2011.

Worked as DBA in Hewlett Packard (HP) from June 2011 to Jan 2012.

Worked as Sr DBA in UST-Global systemsfrom Feb 2012 to May 2014.

Working as Sr Specialist in HCL Technologies from May 2014 to Aug 2019.

Certifications:

ITIL V3 Foundation Certificate in IT Service Management Syllabus.

MCITP: SQL Server 2008 Database Administration

Special Skills:

An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business/management.

Help and mentor junior DBA in determining root cause of problems, determine and implement solutions in database.

Able to achieve mastery of new tools and languages with training,strong interactions and on-the-job experience.

Efficiently develop solution for problems and escalate for confirmation of the solution and other options before acting.

Keep up with the latest technology and utilities in Databases.

Strong troubleshooting and problem solving skills.

Strong ability to prioritize multiple tasks.

Project #1

Client : NOVARTIS .

Role : SR SQL DBA

Company : HCL TECHNOLOGIES

Environment : SQL Server 2000/2005/2008/2008R2/SQL2012/SQL 2014 on Win Server 2003/2008/2012/2014.

Team Size : 10

Duration :May 2014 – Aug 2019

TOOLS : REMEDY,TIVOLI.

Description:

Novartis (NYSE: NVS) is a world leader in the research and development of products to protect and improve health and well-being. The company has core businesses in pharmaceuticals, vaccines, consumer health, generics, eye care and animal health.

Headquartered in Basel, Switzerland, Novartis employs nearly 115 000 people in over 140 countries worldwide to help save lives and improve the quality of life. The Group is present in India through Novartis India Limited, listed on the Mumbai Stock Exchange and its wholly owned subsidiaries Novartis Healthcare Private Limited, Sandoz Private Limited and Chiron Behring Vaccines Private Limited.

Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups.

Maintaining the Database for producing accurate results.

Fix backup failures, address and implement resolutions.

Restoring databases as requested,troubleshoot databases with data consistencyproblems.

Monitoring disk space utilizations, sizing and capacity planning.

Point-in-time Recovery of the production databases, in the event of application failure.

Performed database consistency checks.

Resolving escalated and complex problem within SLAs, Establishing user acceptance performance bottom line.

Managing Security, Permissions of Server Roles and Database Roles.

Implementation, maintenance and troubleshooting the log shipping jobs.

Performing the Fullback up, Differential Backup and Transactional Backup.

Managing Security, Permissions of Server Roles and Database Roles.

Created Maintenance plans and troubleshooting SQL Server Agent Scheduled jobs like Backup, Integrity, Optimization, and jobs regularly.

Implementation, maintenance and troubleshooting the log shipping.

Point-in-time Recovery of the production databases, in the event of application failure.

Performed database consistency checks.

Monitoring disk space utilizations, sizing, and capacity planning.

Adding users in the Database and granting permissions.

Configuring and Troubleshooting Log shipping and replication.

Maintaining Cluster databases in critical Production servers.

Configured and maintained Always on Databases in SQL server 2014.

Followed IQ records to maintain Novartis process.

Involved board meetings as a representative from Database team to explain risk level and SLA with Board Directors.

Project #2

Client : MANPOWER GROUP, UK.

Role : SR SQL DBA

Company : UST GLOBAL

Environment : SQL Server 2000/2005/2008/2008R2 on Win Server 2003/2008.

Team Size : 3

Duration :Mar 2013 – May 2014

TOOLS : SERVICENOW,TIVOLI,LITE SPEED,ORION.

Description:

ManpowerGroup (NYSE: MAN), the world leader in innovative workforce solutions, creates and delivers high-impact solutions that enable our clients to achieve their business goals and enhance their competitiveness. With over 60 years of experience, our $22 billion company creates unique time to value through a comprehensive suite of innovative solutions that help clients win in the Human Age. These solutions cover an entire range of talent-driven needs from recruitment and assessment, training and development, and career management, to outsourcing and workforce consulting. ManpowerGroup maintains the world’s largest and industry-leading network of nearly 3,600 offices in over 80 countries and territories, generating a dynamic mix of an unmatched global footprint with valuable insight and local expertise to meet the needs of its 400,000 clients per year, across all industry sectors, small and medium-sized enterprises, local, multinational and global companies. The ManpowerGroup suite of solutions is offered through ManpowerGroup Solutions, Experis, Manpower, and Right Management.

Responsibilites:

Monitor Sqlserver security regularly by strong auditing.

Support 24/7 datacenter environment by providing on-call support.

Work with business leaders and application developers to meet the organizations goals.

Complied with standard security-related procedures that are based on established best practices and conformity to company policy and adjusted to accommodate Client Security Policy based on mutual agreement.

Managed granular security by defining roles and rights.

Involved in Fine Tuning the Procedures After studying the Processing time through SQL Trace.

Finding the Root cause analysis and document it.

Following all change management process based on the defined policy.

Work with Microsoft support on demand.

Installed & configured Sql database software, associated database tools .

Monitored database activities (i.e. database status, logs, space utilization, locks and long transactions).

Performed all Database related activities such as Database Backup, Restore Operations, Troubleshooting Issues as and when occurs, Performance Tuning, monitoring error logs, jobs etc.

Upgrade SQL Server 2000 to 2005 and 2008.

Adhered to Change Control Procedures.

Estimated disk storage requirements for database software, database files & database administration needs.

Implemented MS SQL Cluster (Active/Passive) in sql2008.

Provided & managed support to Environment of more than 250 Database Servers.

Configured logshipping in Sql2008.

Enabled Compression technique and saved storage space in sql2008.

Configured Partition table and create partition maintenance script.

Use SSRS to create sqlserver backup report and Capacity planning report.

Configured DB mirroring.

Enable Change data capture for auditing.

Participated in testing and implementing an enterprise Disaster Recovery Plan.

Provided optimal database file layout for utilization of storage and performance acceptable to client.

Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.

Participate in SQL Server Virtualization.

Configure High availability groups in sql2008.

Use Litespeed for backup and recovery in Sqlserver.

Project #3

Client : Well point, US.

Role : SQL DBA

Environment : SQL Server 2000/2005/2008 on Win Server 2003/2008.

Team Size : 6

Duration :Feb 2012 – Mar 2013

TOOLS : TSRM,TIVOLI,LITE SPEED, MAXIMO.

Description:

Health care is changing and WellPoint is leading the way to help improve the system, make health care easier for consumers to access and use, and improve the health of the people we serve. Our affiliated health plans and companies are empowering consumers and driving innovation to control costs and improve the quality of care everyone receives.

Responsibilites:

Databases are backed up on a regular basis by monitoring full, differential, transaction log backups.

Fix backup failures, address and implement resolutions.

Restoring databases as requested; troubleshoot databases with data consistency/torn page problems.

Monitoring disk space utilizations, sizing, and capacity planning.

Point-in-time Recovery of the production databases, in the event of application failure.

Performed database consistency checks.

Managing Security, Permissions of Server Roles and Database Roles.

Implementation, maintenance and troubleshooting the log shipping jobs.

Upgraded servers from SQL Server 2005 to SQL 2008.

Side by Side upgrade also performed from SQL2005 server to new SQL 2008 server

Incident Management: Performing Standby DBA, Working on day-to-day operation and database troubleshooting, working closely with other team such as NT, Network, and Server tools to identify and troubleshoot the problem.

Recover database in case database crash, using complete and incomplete recovery.

Perform day-to-day operation like Configuration Management, Incident Management, Problem Management, and Change Management.

Assist Application team during Application Development, Testing, and Deployment to Production System.

Creating, Scheduling and troubleshooting jobs in Sql server.

Creating Users and granting permissions accordingly.

Resolving the Orphaned users in the databases and checking for the Client Connectivity.

Worked on ITIL management works,

Creating changes, incidents,service request and implementing timely.

Working on Audit remedaitionactivities .

Follow up with application team and scheduling meetings and revoking /granting appropriate permission as per application team confirmation .

Project #4

Client : Marathon Oil and Petroleum, US.

Role : SQL DBA

Environment : SQL Server 2005/2008 on Win Server 2003/2008.

Team Size : 3

Duration :June 2011 – Jan 2012

TOOLS : DBSPI,DBMON,SC,SM7,OVSD,REMEDY .

Description:

Marathon Petroleum Corporation (MPC) is in the business of creating value for our shareholders through the quality products and services we provide for our customers. We strongly believe how we conduct our business is just as integral to our bottom line. As a result, we strive to always act responsibly with those who work for us, with those business partners who work with us, and in every community where we operate.

Responsibilites:

Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups.

Maintaining the Database for producing accurate results.

Monitoring and maintaining 150+ of databases.

Fix backup failures, address and implement resolutions.

Restoring databases as requested; troubleshoot databases with data consistency/torn page problems.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS).

Monitoring disk space utilizations, sizing, and capacity planning.

Point-in-time Recovery of the production databases, in the event of application failure.

Performed database consistency checks.

Resolving escalated and complex problem within SLAs, Establishing user acceptance performance bottom line.

Managing Security, Permissions of Server Roles and Database Roles.

Implementation, maintenance and troubleshooting the log shipping jobs.

Project #5

Client : Master Card, USA.

Role : SQL DBA

Environment : SQL Server 2005/2008 on Win Server 2003.

Team Size : 8

Duration :April10 – July 2011.

TOOLS : Tivoli, GSM,Veritas .

Description:

MasterCard Worldwide continues to provide a unique combination of expertise, industry-leading insight, and globally integrated resources that the company leverages to deliver value to constituents. MasterCard is committed to innovating and growing the range of products and services the company brings to market through our strong partnerships with our customers.

Responsibilites:

Monitor and maintain 250+ databases in Production, UAT and Development Environments

Design, propose and Implement database environment to achieve agreed database availability commitment.

Design, recommend and implement Backup Strategy.

Verify backups and error logs on the servers and troubleshoot any failures or alerts, open problem tickets if necessary to work with technicians from other departments

Performing database Design, Creation, Migration, MTP (Move to Production) in multi platform Server environment.

Respond to problem tickets assigned to me and fix any database issues promptly Update and work on projects that I have been assigned to as a resource from the Database Management team.

Implemented and Troubleshooting Log-Shipping, Replication and Database Mirroring as high availability solutions in both SQL 2005& 2008 serves.

Upgraded servers from SQL Server 2005 to SQL 2008.

Side by Side upgrade also performed from SQL2005 server to new SQL 2008 server

Follow change control procedures to migrate code into production servers.

Creating and Trobleshooting of Maintenance plans.

Work closely with other team in other region to deliver the service.

Perform SQL patching: Patch set upgrade, Security patch and bug fixes patch.

Assessment of database security, and perform necessary action to protect database such as Security patching, Remove unnecessary privilege, and get the customer to sign Risk Acceptance Form.

Incident Management: Performing Standby DBA, Working on day-to-day operation and database troubleshooting, working closely with other team such as NT, Network, and Server tools to identify and troubleshoot the problem.

Recover database in case database crash, using complete and incomplete recovery.

Perform day-to-day operation like Configuration Management, Incident Management, Problem Management, and Change Management.

Assist Application team during Application Development, Testing, and Deployment to Production System.

Creating, Scheduling and troubleshooting jobs in Sql server.

Creating Users and granting permissions accordingly.

Resolving the Orphaned users in the databases and checking for the Client Connectivity.

Thank you

Contact this candidate