Post Job Free

Resume

Sign in

Sql Server Customer Service

Location:
Levittown, NY
Posted:
February 13, 2016

Contact this candidate

Resume:

Sidharth Sharma

** ***** ****

Levittown

NY ****6

+1-516-***-****

actips@r.postjobfree.com

Residential Status

Permanent Resident\Green Card

Objective

Summary

Technical Skills:

Education:

Certifications:

I would like to secure a position within a highly recognised progressive organization, where I will have the opportunities to demonstrate my abilities in group work, communication, decision-making, and leadership.

I wish to secure a position that I will enjoy and one that will present me with the challenge and options for further training and advancement according to my performance and initiative.

Ultimately it is my desire to become a valued member of a productive team and broaden my knowledge whilst working within a business environment

7+ Yrs of technical/consulting experience as DBA in Microsoft SQL Server and Oracle 10g/11g on Linux, HP-UNIX & Windows.

Maintaining and implementing 2 Node Cluster in SQL server.

Maintaining and implementing Oracle 11g RAC

Experience in Database up-gradation and conversion from Oracle 9i/10g to Oracle 11g.

Experience in different phases of SDLC which include Analysis, Design, Development and Testing and working closely in implementing DB Auditing. .

Maintained Replication, Logshipping and Mirroring on different servers.

Implemented High Availability/Disaster recovery strategies.

Performing capacity Planning, Backup/Recovery strategies.

Performance tuning of SQL server and Oracle 10g/11g databases, reviewing AWR.

Strong RDBMS, SQL & TSQL experience. Written Packages, Procedures, Functions, Triggers to incorporate complex business logic and writing shell scripts to automate day to day tasks.

Strong experience in using tools such as SQL*Plus, TOAD, RMAN and Export/Import, Data Pump.

Strong Analytical, Communication, organizational, Troubleshooting & interpersonal skills.

Providing 24/7 on call support for very large databases (VLDB) and Data Warehouse environment.

Windows Server 2003 and 2008 R2, Windows XP, Windows 2000 server (AD), Windows 2000 professional, Windows NT, Windows 98, Windows IIS Web Server 7.0, SharePoint 2010, Microsoft Outlook, SQL Server 2000, 2005,2008 R2, 2012 and SQL2014 and Oracle 10g and 11g.

Computer proficient with MAP (Microsoft Assessment and Planning toolkit), Netbackup tool from Symantec, MS Office Tools: Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft FrontPage, Microsoft PowerPoint, MS DOS, Microsoft Project, Windows applications, ServiceNow, Remedy and Altiris helpdesk tools.

Languages: SQL,C++, Visual Basic, Windows Powershell, HTML and Rational tools as well as experience with IIS, DNS, FTP, HTTP and TCP/IP

Masters of Business Administration (MBA)

Bachelor of Technology

Microsoft Certified Solution Associate (MCSA –SQL Server 2012)

SQL Server certification from Microsoft.

Oracle Certified Associate (OCA – Oracle 11g)

Oracle DBA Certification from Oracle University

Experience

February 2013 – December 2015 Primary Health Care Ltd Australia.

Database Administrator

Perform day-to-day database administration activities for operational SQL Server & ORACLE databases.

Perform database tuning and database maintenance on SQL Server & ORACLE databases.

Responsible for SQL Databases Backup/Restore, Integrity check and maintenance of SQL 2005, 2008R2, 2012 and 2014.

Responsible for Oracle database backups and restores using RMAN and Data Pump.

Experience in Database Mirroring, Log shipping and Replication.

Experience in managing SQL multi node clusters on SQL Server 2008R2 and SQL 2012.

Managing and maintaining Oracle databases for SAP and various in-house developed applications.

SQL Server service Pack and version upgrade from 2005 to 2008R2 and 2012.

Collaborating with the BI (Business Intelligence) team for building and maintaining a data warehouse server to be used for extensive data warehousing and ETL.

Responsible for creating and managing SSIS (SQL Server Integration Services) packages and then delivering reports using SSRS (Reporting Services).

Providing support as required ensuring the availability and performance of data and BI environments for all the users.

Strong competency and experience in creating and migrating SSIS packages for automation and reporting.

Participates in disaster recovery planning and drills..

Leads and completes assigned complex and/ or long-term projects within budgetary and scheduling guidelines.

Provides weekend and off hours support, as necessary.

Managing Daily DBA tickets.

Capacity planning to meet future needs of the business by consolidating SQL instances, by database migration or by creating new instance.

Provides 4th level Database System support (administration) on multiple platforms. This may include storage management, recovery and performance issue resolution.

Reviews and tunes initialization parameters, memory structures and physical data layout for optimal performance.

Providing assistance to developers to troubleshoot and optimize queries and being involved throughout the SDLC. .

November 2010 – January 2013 Impinge Solutions Australia

Database Administrator

Responsible for Installation/configuration/upgrade/patching of SQL Server.

Responsible for SQL Databases backup/restore and maintenance of SQL 2000, 2005, 2008, 2008R2 and 2012.

SQL DBA Support to Practice Management and Financial Applications.

Managing and maintaining Oracle 11g databases.

Responsible for Oracle database backups and restores.

SQL Database consolidation and migration to new SQL Server Cluster.

Responsible for creating, migrating and maintaining SSIS packages used for reporting using SSRS and SSAS.

Collaborating with BI developer for maintaining Fact tables, Dimensional tables and SSAS Cubes in SQL Server data warehouse used for ETL.

Daily operational tasks to administer SQL server, IIS and SharePoint fleet.

Oracle/SQL Server database upgrade & migration.

Operates within established internal audit.

Capacity planning to meet future needs of the business

Ensuring High Availability / Support for all SQL Server (2005, 2008) Cluster and non cluster databases.

Day to day support, event coordination, fault resolution and resolving daily database tickets.

Managing and being involved with software / hardware upgrades, system enhancements and new implementations

Participates in disaster recovery planning and drills.

August 2009 – October 2010 Seasia Infotech Australia

Product Support\Database Support

Responsible for Providing IT Support to weekly and Monthly Reports for various business units.

Responsible for various data mining activities using Microsoft Access and SQL.

Responsible for managing and maintaining data.

Providing Support to SQL Server, DTS, Including data cleaning, performance tuning and troubleshooting issues raised by business

Performing various tasks on Windows Server 2003

Managing Users and Groups on Windows Server 2003

Support various Microsoft applications.

Hardware and software Troubleshooting

Processing Client Requests.

Maintaining documentations for all support activities including product development, troubleshooting and marketing activities.

February 2008 – May 2009 Data#3 Australia

Help Desk (Part Time Work Experience)

Logging the faults in the system

Helping the end users to fix up daily computer problems.

Helping the end-users with products and features

Accessing and manipulating the different systems for choosing the right track to process the fault

Taking charge and responsibility of my jobs, chasing them up by communicating with different departments, logging complaints and escalating the faults according to their priority

Installing to new programs and upgrading the existing software’s.

As a result, gained extra ordinary customer service skills, working under pressure and keeping up the company standards, while reaching the daily stats and following companies health and privacy policies. Dealing with business customers improved my communication skills and increased my multi-tasking capability

Education

Masters of Business Administration (MBA)

2007 -2009 Australian Catholic University. North Sydney (Australia)

Bachelor of Technology

2002 – 2006 SUSCET Mohali (India)

Certifications

Personal Profile

Microsoft Certified Solution Associate (MCSA –SQL Server 2012)

SQL Server certification from Microsoft.

Oracle Certified Associate (OCA – Oracle 11g)

Oracle DBA Certification from Oracle University

I am a dedicated business student with knowledge and skills in business and information technology. Whilst completing my degree, I have gained experience in working within teams, project planning, research, and communicating effectively with others.

Having worked within groups has allowed me to acquire team work skills and understand the importance of co-operation and trust. I am a self-motivated and enthusiastic individual willing to learn new concepts and ideas.

One of my many strong points is that I am bilingual and therefore have had the opportunity to deal with people from various cultures and backgrounds. I enjoy community involvement and over the years have taken part in many cultural events.

I enjoy challenges and have always searched for ways to further improve my knowledge, skills, and abilities. I am always open to suggestions and willing to listen to the advice of others in order to gain a better understanding of others and myself.

Demonstrated Skills and Abilities

Major projects

-Providing support during Data Centre Relocation ensuring minimum downtime to the core systems.

-Leading and completing Microsoft Licensing project for SQL server.

-Migration of System and User databases to new LUNs in data centre in 2 node cluster.

-SQL Server 2005 Upgrade to SQL Server 2008, 2012

-SQL Server 2000 Upgrade to SQL Server 2005

-Database development using Microsoft Access and MS SQL Server.

Other

-Business and Project Management.

-Customer Service

-Communication/Negotiation and interpersonal skills

-Problem Solving and decision-making

-Planning and Organisation

-Teamwork

-Work Unsupervised

-Translator/ Advocate: Punjabi, Hindi, and English.



Contact this candidate