Sanjeewa W. Indraratne

** ******* ******, **********, ** 01824 917-***-**** C 781-***-**** O abqgcf@r.postjobfree.com

SYSTEMS ADMINISTRATOR

Proven Success in Systems Optimization and Strategic IT Solutions

Accomplished systems administrator with 12 years of experience managing server infrastructures and data-base operations across multiple platforms (Unix & Windows). Effectively plan, install, configure and optimize the IT infrastructure to consistently achieve high availability and performance.

Proven ability to create and deliver solutions tied to business growth, organizational development and systems/network optimization. Skilled problem identifier and troubleshooter comfortable managing systems, projects and teams in a range of IT environments.

Highlights of IT SkillsSystems Installation,

Configuration & Upgrading Database Design &

Management Hot fixes & Patches Updates Training & Mentoring

Professional Experience

06/11 - Present: Application Engineer/System Administration Allscripts 5.5 & MS SQL2008, Lahey Clinic, Burlington, MA.

Key Contributions: Daily System Maintenance and Performance Monitoring and Reviews.Access control Administration (Users, Groups, Applications and devices)Perform Backup Recovery, and Database RefreshDaily DBCC and integrity checks of databases across the Hospitals Maintain and Monitor Event tracker for MSSQL backups (Control files).Monitor Daily, Weekly Users activities & implementing necessary actions to optimize performanceWriting in-house SA Operational guide for entire System Administration groups.Investigate and resolve escalated problem tickets for all the Hospitals, also collaborate with Applications Vendor (Allscripts) on application issues.SQL optimization. Working as a team member with other DBA's & System Administrators to ensure 24 hour x 7 day a week. Apply Patches & Hot Fixes to all servers (Applications and Databases) Apply ExitCare Quarterly updates Implemented Error Alert Automated SystemMaintain and Monitor Ancillary Applications (Pentax)Develop and Maintain Share Point Sites

11/06 – 06/11: DBA/System Administrator, MSSQL Server 2000/2005, New York Presbyterian Hospital, New York.DBA in MSSQL 2000/2005 System Administrator in Eclipsys SCM 4.5 & TSC 5.0 Applications & serving more than 100 Remote & Physical Servers

Key Contributions: Daily System Maintenance and Performance Monitoring and Reviews.Access control Administration (Users, Groups, Applications and devices)Perform Backup Recovery, and Database Refresh, Data Transfer Service (DTS/SSIS), Database Replication (Golden Gate).Daily DBCC and integrity checks of databases across the Campuses Maintain and Monitor Event tracker for MSSQL backups (Control files).Monitor Daily, Weekly Users activities & implementing necessary actions to optimize performanceAdministrate and Maintain multi campuses Report ServersMS SQL 2005 Report WritingWrote in-house DB Operational guide for entire DBA & System Administration groups (East & West Campuses).Investigate and resolve escalated problem tickets for all the campuses, also collaborate with Applications Vendor (Eclipsys) on application issues.SQL optimization. Working as a team member with other DBA's & System Administrators to ensure 24 hour x 7 day a week support of all 3 Hospitals databases. Apply Patches & Fixes to all servers (Applications and Databases)Playing Major Role in upgrading from SCM 4.5 to TSC 5.0Create Transmission Policies to Printer Queues

03/06 – 11/06: DBA, Sybase Server 12.5.3 with UNIX AIX 5, Moody’s Investment Services/Syntel Inc, Jersey City, NJ.DBA for Sybase serving 80 remote Servers locations and 50 Microsoft SQL Servers.

Key Contributions: Daily System Maintenance and Performance Monitoring and Reviews.Administered Server Monitoring system (Snappimon Version 3).Access control Administration (Users, Groups, Applications and devices)Performed Backup recovery, and Database refresh.Maintained and Monitored Event tracker for Sybase backups (Control files).Administered & Generated Weekly User and DBA Audit Sarbanes-Oxley Act (SOX Compliance) reports.Wrote in-house DB Operational guide for entire DBA group (Inshore & Offshore).Coordinated Offshore DBA’s activities.Produced weekly offshore activities report.Performed Lotus Notes Requests.SQL optimization, Data Transfer Service (DTS/SSIS), disaster recovery planning and testing. Worked as a team member with other DBA's to ensure 24 hour x 7 day a week support of all corporate databases. Collaborated with top management to enhance both inshore and offshore servicesOverseen offshore work performance on daily basis by emails and phone callsCoordinated weekly or emergency DBA meetings

09/05 - 12/05: Database Consultant Sybase 12.5 & MS SQL Server 2000, Blue Crystal Solutions, Adelaide, Australia.

Key Contributions: Access control Administration (Users, Groups, & Applications)Performed Database Modeling and Designing, Data Transfer Service (DTS)Application support in Windows 2000/2003 server platform environmentsProvide training to local staffsResolved existed system problems

Manager of a,Web and Client Server development operation serving 300 clients. Several ongoing Web and client server development projects utilizing Visual Basic 5, ADO, Microsoft SQL Server 2000, Access 2000, Windows 98/00/XP and Windows NT 4. Object Oriented Life Cycle used to complete web projects with a consulting firm.

Recent projects include: Web electronic commerce applications for customer relational and supply chain management. Extranet Customer Support and Activity Tracking Systems; relational database modeling using SQL,

05/05 - 08/05: DBA MS SQL Server 2000 (Raiser Edge), Housing Works, New York, NY.

Key Contributions: Database Designing, Performance Tuning, Data Transfer Service (DTS), Develop and Coordinate Network Operational, Data Recovery and Backup procedures for all SQL based enterprise systemsApplication Support, Problem Resolution related to the RDBMS in windows 2000/2003 platform environmentsSubmit Organization monthly reports to New York State Government.Participated in the Disaster Recovery and business continuity Planning.Installed MS SQL Database & software applicationsCoordinated non-profit programs, and provide project support

Other responsibilities include: DBA for all SQL Server development, managed and maintained client relational and supply chain management application on workstations, managed consultants and programmers on various client server & web based systems. Close collaborate with upper management committees on new development, research, corporate strategy and budget planning.

Managed internally requested enhancements to over 400 workstations from call centers in 3 cities. I personally resolved 5 years old DB errors programmed and implemented over 2000 enhancements and changes to meet internal and external client’s needs.

06/02-05/05: Asst. DBA in MS SQL 2000/Sybase 11 & 12.5/Oracle 9i, Globe Institute of Technology, New York, NY.

Technical Projects:Database Connectivity in Java Language, Database Programming, BCP/DTS/DB backup/restore, SQL Server 2000 Clustering, and Database modeling and designCreating users and database objects such as: Tables, Views, Indexes, Rules, Defaults, Stored Procedures and TriggersAccess control Administration (System Utilities, Backup recovery)Wrote scripts with Bourne Shell for Administrative tasks in the UNIX environment, and Windows scripts in Windows NT, 2000, 2003, Maintaining, Loading & Unloading users’ information. Maintained and Administer print servers. Administered Performance Monitoring and TuningInstalled and configured Software ApplicationsProvided support and collaborated on technical related coursesUpgraded lab service for both faculties and studentsSupervised and provided training to Lab Assistants

Established project schedules and completed 5 new software releases, all with zero downtime to clients. Managed and supervised a group of 10 instructors and 2 programmers on PC projects including Educational systems (exams) & and Re-engineered an enrollment system written in SQL/Sybase to a client server system using Java using Method One methodology. The new system saved 25% of operator training time, reduced operator wrap-up time by 45% and sped up on call time by 35%. Meanwhile, I also recruited a contract lab instructor for 1 year.

Independent consultant on several projects including: management consultant on team that produced innovative Video Rental and Sales System, Car Rental System, Stock Control System, Pay Roll System.

01/99-05/02: DBA/Developer/Programmer in Sybase12.5, 725 Video Inc, New York, NY.

Key Contributions: Create and maintain Employees, Stocks, Payroll DatabasesCreate user & database objects such as: Tables, Views, Indexes, Rules, Defaults, Stored Procedures & TriggersRetrieve manipulated data using T-SQL & SQLRun database applications using DB LibrariesResponsible for procuring new software purchases and licensingInstalled software applications

Re-engineered a call center legacy system written in SQL/Sybase to a client server system using Java. The new system saved 25% of operator training time, reduced operator wrap-up time by 45% and speed up on call time by 35%.

Design through completion of a Payroll, Stock Control, and Sales systems using IBM PC with Windows (Sybase, Java). Conducted extensive microcomputer hardware and software study, which led to the creation of a corporate Information Center. The new system saved 50% of operator training time, reduced operator wrap-up time by 45% and increased sales volume by 35%. Also recruited contract programmers for 2 years.

09/96-12/98: Computer and Sales Manager, 725 Video Inc, New York, NY.

Key Contributions: Automated and integrated an entire Corporation, thereby increasing productivity by 50% and reducing cost by 50%.Created and maintained Employees, Stocks, Payroll DatabasesCreated user & database objects such as: Tables, Views, Indexes, Rules, Defaults, Stored Procedures & TriggersRetrieved from manipulated on data using Transact SQLRun database applications using DB LibrariesAssigned permissions to users, Load & Unload Databases using System Utilities

Implemented Payroll Stock Control, and Sales system using Java under Sybase ODBC. Redesigned entire sales and management system of organization. I also authorized to hire contract sales people for 3 years.

Additional IT Experience

Specialty

Category

Last Used

1 (low) to 10

Years Used

DBA - SQL Server 2000, 2005, 2008

Database

Current

10

12

DBA - Sybase 11,12.5,12.5.3

Microsoft Office/Visio

Clinical System Apllication [Sunrise Clinical Manager 4.0, 4.5, 5.0, & 5.5 (Allscripts)]

Application

2012

10

Education & Training

2012-03: English Business Writing, Skill Path, Boston, MA

2011-11: Allscripts Corporation Atlanta, GA. Sunrise Enterprise 5.5 System Administration.

2010-05: MBA Degree, New York University, NY.

2009-12: Completed the PMP Class & prepare to take the PMP Exam

2009-11: Netlan Technology New York, NY. MS SQL2005 Reporting Services

2009-09: Eclipsys Corporation (Online)TSC 5.0, Prescription Writer 5.0 for End Users,

Sunrise Acute Care Orders/Results 5.0 for End Users, Sunrise Acute Care 5.0 Documentation for End-

Users, Sunrise Ambulatory Care Manager 5.0 for End Users

2009-06: Eclipsys Corporation Atlanta GA. TSC 5.0, Introduction to Reporting - v.5.0

2008-09: Golden Gate Software Inc,Fundamentals of Golden Gate for MS SQL 2000/05.

2007-08: Netland Technology New York, NY. Maintaining Microsoft SQL Server 2005 Database.

2007-07: Netland Technology New York, NY. Administering and Automating a Microsoft SQL Server 2005 DB.

2007-04: Netland Technology New York, NY. Implementing a Microsoft SQL Server 2005 Database.

2007-02: Eclipsys Corporation Atlanta GA. Sunrise Clinical Manager Application 4.5 Manager Database.

2005: MSc in Telecommunication and Information Management, Polytechnic UNIV, NY.

Advanced Certificate in Database Administrating MS SQL Server 2005 and Oracle 9i,

2004: New Concept Training Center, NY.

2002: BS Computer Sciences with Honors, Globe Institute of Tech NY.

SPECIAL

SKILLS: Excellent problem solving skillsWith highly progressive management experience, team leadership and technical skillsExcellent interpersonal skills and rich experience in working close with senior managementAble to handle multi-tasks, and internal vs. external customersVery detail oriented and fast thinker Have strong business vision, great sense in combine using both management skills and technical

skills in changing business environment Willing to learn, able to work under pressure and tight deadlines, and have great sense of urgencyBilingual in English and Sinhalese

ACHIEVEMENT:Scholarship (Master Degree)Graduated with Cum Laude in May 2002 (Bachelor degree)

COMMUNITY

SERVICE: Organized a Tsunami Disaster Fund Raiser.

Active member in Sri Lankan Communities (New York/ Massachusetts) USA.

Professional

Membership: Member of Project Management Institute.

Relocation: Yes

Legal Status: Canadian Permanent Resident.

Contact this candidate