SQL DBA

Skills Matrix:

Skill Experience in Years Date Last Used

(mm/yyyy) Self Rating Scale 1-10 (10 being high)

Microsoft SQL Server 2008 (SSMS,SSIS,SSRS,SSAS,DTS) 2 Current 8

Microsoft SQL Server 2005 (SSMS,SSIS,SSRS,SSAS,DTS) 5 Current 8

Microsoft SQL Server 2000

(Enterprise Manager, SSRS,SSAS,DTS) 10 Current 8

Microsoft SQL Server 7.0/6.5

(Enterprise Manager, DTS) 10 Current 8

Microsoft Office (Excel, PowerPoint, Visio, Access, Project, Word) 8 Current 10

Oracle 10G,11G 2 Current 5

IBM (DB2,UDB) 1 10/2009 5

Windows OS (2008,2003,2000,NT,XP,Vista,7) 10 Current 10

MS Sharepoint (3.0 and 2007) 2 Current 8

Ombudsman/ACT2005 2 Current 10

Cover Letter for Recruiter/Employer

Hi,

I would not like to waste your/my time but if you are seeking a result oriented then please review my resume. I presently have my qualification accessed and approved from Washington, New York and Texas states. I am seeking for an employer who can transfer my visa + support in relocation (US$ 8000 = flight ticket and relocation adjustments like house rental security deposit) such that I can work full-time/permanently for this employer (unlike my last experience in which major chunk of my salary was taken by my third party vendor/employer) . I am presently on transferrable E3 Visa which is equivalent to EAD (visa awarded to Canadian Residents). I have ranked 4th in the competitive exam held by State Of Wisconsin with 86.32%. I have ITIL, Stock Market and Currency Management (conversion) experience which I acquired during my work with Dept. Of Treasury. You can get local DBA/IT Professionals but not an exceptionally good candidate like me. I can be reached anytime on my home number: +612******** to discuss in detail the asset I can be to the employer company.

Thanks,

Shobhendoo

 

Resume

Application for the position of DBA/ IT Consultant

Dear Sir/Madam,

I would like to present this application for advertised position. I am preparing for this position due to my extensive professional experience in the IT industry. The accomplishments noted within the accompanying resume will supply an insight into value and enthusiasm that I would bring to the position.

I possess a vast commercial experience as a database administrator and team leader initiating from August 1997 to current. During this tenure I have contributed and gained experience globally and locally with various government and private sector organizations. I presently possess extensive knowledge of the IT industry, am always eager and a quick learner.

I have completed BE is Electrical and Electronics engineering and have vast commercial experience in Database tuning, migration, filtration, clustering of Itanium servers and HP Proliant Blades, Development, Administration and maintenance on Window 2008,2003,2000,Vista and XP systems.

I have worked in network-based environments for handling system operations and management of databases. Within my responsibilities as a database administrator I have contributed to maintenance plans, writing stored procedures for performance tuning SQLMail configuration, changing the dbowners and database backups for almost 200 servers. In addition I have contributes to daily database backups of a few TBs. I have successfully leading a team of 5 Application DBAs and 5 Web Programmers. My prior experience contributes to playing a pivotal role of Operational DBA using N-tier Architecture and Administration on SQL Server 2000 (MSDE), SQL2005 and SQL 2008 for clients ranging from Hospitals, Cooperative Societies, Pollution Control Board, Housing Boards, Financial Institutions, Chain of Restaurants, and Educational Institutions, etc.

Due to the increasing levels of hacking and sensitive nature of data stored, security was also my primary aspect of the work and hence I played a pivotal role of installing necessary patches. As a software support and database administrator I have performed critical role of suggesting and understanding the processes and architecture of the SQL Server database, I have fine-tuned the day-to-day performance which was the backbone of our organization's IT system. It involved lot of in-depth studies including preparation of Hardware and Software Requirement Specifications (H/SRS) and relevant documentation and presentation of project proposals to various clients. It also involved answering technical queries to customers and liaising with them for successful completion of the project.

I have had experience in working in a team environment including liaising with development team and with clients. This has developed my time management, interpersonal and communication skills. I have also been responsible for the development and maintenance of systems by installing updates and project documentation for software developed.

If you are looking for a dependable, results-oriented professional with a solid performance record, I would be interested in speaking with you to discuss the value that my strength and experience can bring to this position.

With Regards,

Shobhendoo Mohan

Email: **********.*****@*****.***

 

Mohan SHOBHENDOO

Male, 38 yrs, Australian Citizen

5/9-11 Hart Drive; Constitution Hill

NSW-2145; AUSTRALIA

Phone: (02) 9688-2093

E-mail: ***********@*****.***

OBJECTIVES

Work as a dependable Operational DBA

EDUCATION

JULY 1992-JUNE 1996

Bachelors in Electrical And Electronics Engineering, Mangalore University India

EXPERIENCE

EMC,Bellevue and Microsoft,Redmond USA as Operational DBA (Nov 2009- Jan 2010 end)

State Of Connecticut, (Department Of Children And Families), 505 Hudson St, Hartford, USA as Operational DBA /System Administrator (April 2008- November 2009)

Australian National University (Research & Development Division), Fellows Road, Canberra as SQL Server DBA (November, 2007- February, 2008)

(ANU has been accredited as Australia’s Number #1University and ranks 56th position in the world universities)

INTACT (Department of Treasury), Callum Offices, ACT: SQL Server DBA/Windows Administrator (March, 2007 – July, 2007)

Vodafone (Mobile Telecom Industry), Chatswood, NSW Project Leader/DBA (October, 2006 - February, 2007)

Reach Global (Optical Fibre Industry), Mona Vale, NSW Operational DBA (July, 2006 - September, 2006)

TAFE Mt. Druit and Blacktown, NSW (June, 2004 – June, 2006)

Pivotal role in project supervision to TAFE students in software and web based projects. The back-end database used was SQL SERVER (7.0, 2000 and 2005) with GUI (Graphical user interface) Visual Basic. The role also comprised of affiliating the diploma holders with Microsoft SQL Server 2005 Integration Services (SSIS) which assisted them in creating robust and complex solutions for extracting, transforming, and loading data (ETL). Latest handled project- Library Management Package involving Visual Basic and Microsoft SQL Server software. Cooperative Societies, Housing Boards, Financial Institutions, Chain of restaurants, Educational Institutions, State Pollution Board.

IITT COLLEGE OF ENGINEERING Head Of IT Department/SQL DBA (April, 2002 - May, 2004)

HARTRON INFORMATICS SQL DBA (July, 1999 – April, 2002)

BECON INDUSTRIES INDIA LTD / BHAIE Engineering Corp. (BECON) Software Developer (August 1997 – June 1999)

OTHER RESPONSIBILITIES

In the capacity of an Operational Administrator my roles and responsibilities included:

 Managing Active Directory with reference to security credentials, Group Policy and server management.

 Executing the UAT (User Acceptance Testing) for the databases based applications and hoisting of Websites using IIS.

 Maintaining the SQL Server health, backups and restoration of databases in the order of few TBs.

 Managing and optimizing database, creating jobs and schedules so as to avoid dead-locks.

 Maintain database and application level security by monitoring/granting and revoking privileges to vendors/users on the Production server.

 Maintaining Change Management in the Sharepoint Environment by creating CAB tickets and tools like Visual QSM. All developed objects are propagated to production by me after get approval from Operational Manager.

 All Production Servers and Development/Staging Servers databases are backed up using a third party tool “Redgate Toolbelt” and monitored using SQL Sentry.

 Gathering and documenting business requirements to support key enterprise projects and project team members and Identifying and promoting process improvement opportunities for gathering requirements

 Create and maintain Project Charter and Customer Requirement Template for each assigned project

 Scope and Assess each project impact from each grouping and perform risk analysis with Subject Matter Experts

 Update existing and or develop new Use cases based on Project Impact

 Create process flow diagrams and sync up those diagrams with IT team for accuracy and maintain them for future reference

 Prepare Business Process solution and to drive high level Impact summary to the Business and system used

 Perform Gap analysis between current system and future system to make sure all the data elements need to perform and the business has been taken care of

 Conduct JAD (Joint Application Design/Development) sessions with business and or IT to support all key projects that have already been funded

 Facilitating review of completed business requirements with project stakeholders, business functional and IT partners in order to secure buy in sign off requirement deliverables

 Supporting the development of functional requirement and system design to ensure that they meet defined business and project objectives

 Make sure all the independencies are meet during detail requirement and sync up the requirement with internal Domain partners

 Maintaining the Business Requirement Traceability document in SharePoint

 Support change control of documents during and/or after the project being implemented

 Supporting the development of functional requirements and system design to ensure that the requirements met defined business and project objectives.

 Make sure all Internal management reporting as well as external client facing requirements are met during detail requirement and validating that reporting requirement will meet the business needs

COMPUTER EXPERIENCE

NETWORK/OPERATING SYSTEMS: Windows 2003,2008/XP Professional, MS DOS, Networking TCP/IP, Ethernet, Remote Server, FTP Server, IBM Mainframe

LANGUAGES/RELATIONAL DATABASES: IIS (Internet Information Server), MS SQL Server 7.0/2000/2005/2008 (SSMS,SSIS,SSRS),Visual Studio.Net, IBM DB2, UDB, Oracle

APPLICATIONS: Redgate Toolbelt, SQL Lite, SQL Sentry, Reporting Services, MS Office (MS Access, MS Excel, MS PowerPoint, MS Word), Visual Studio.Net, Crystal Report 11,MS Outlook, Virus Scan Software McAfee, Norton Antivirus Scan, Other Anti Virus Tools and patches

Additional Information:

• I love watching college football and playing tennis. In addition I prefer short excursion.

SKILLS

• I am result oriented, possess excellent communication as well as administrative skills and therefore can prove an asset to the organization.

REFEREES

Can be provided upon request

Contact this candidate