Sql Server Support

Dr Bhaskara Rao Pilak

(Australian Citizen, E* Visa eligible)

** ********* ***** ***** ***: +61-41-356-****

Thomastown, Melbourne 3074 VIC US: +1-248-***-****

Australia ******@*****.***

Availability Immediate

Qualifications: PhD in Information Technology from IIT Chennai (1982)

Career Objective

To associate with an organization with an aim to ever increase the productivity, lay emphasis

on data security, data protection, high availability, high performance using advanced

infrastructure and latest database technology .

This allows me to put in use my broad and deep expertise in database technology and utilize

new innovations.

Career Summary

Subject matter expert in SQL Server and Oracle technologies

Worked for large companies including IBM, Deloitte, CSC, HP,PWC, Accenture, UXC,

Tennix, Taxation, Government departments, ministries, Phillip Morris, Telstra,

20 years of experience in SQL Server, Oracle and Sybase technologies including

• Advise and guide on the architectural, and capacity aspects of database environments

• Scope and Architect database infrastructure for high transaction, high availability and

high performance

• Architect large OLTP and DSS databases for performance and data integrity

• Frame processes and procedures around database operations, design and development

• Build data warehouse and design and develop ETL for sourcing the data from

transactional environments

• Extensive knowledge of SQL Server Technologies including Replication, SSIS,

SSAS, SSRS [Reporting Server], Service Broker, Text Indexing, SQL clustering,

Database Mirroring, Log Shipping

• Set up clustering, mirroring, log shipping particularly using latest SQL Server 2014

technology

• Implement design, development and production environments and support

development and operations support

• Project management expertise in SQL Server and Oracle projects and data migration

Technical Skills

Software Languages TSQL, DBA, UNIX, Java, XML, ETL

Database SQL Server 6.5, 7, SQL Server 2008, SQL Server 2012,

SQL Server 2014, Oracle 6, 7, 8i, 9i, 10G, 11G

SYBASE 11.5, 12.5, 15

Management Tool MS Project, PRINCE2

Other Tools Visual Studio 2014

OS Known Windows-2012 Server, UNIX, LINUX

Experience Summary

1. Australian Taxation Office (IBM) Melbourne May 2013 to Feb 2015

Responsibilities (as Senior Database Specialist)

Manage ATO Database Environments (5 levels including production)

Set up change processes and procedures for database development and change migrations

Set up release processes and procedures for production deployment

Coordinate with the database change control board for change deployments, database

environments set up

Review ATO standards for database design, development and SQL standards

Responsible for the databases, database design standards, set up disaster recovery and high

availability set up in production, emergency fix and performance environments

Design and develop strategy for the database backups (database sizes of between 2 and 3

terabytes), performance tuning, capacity planning

Create database standards, documents, database design and change migration processes and

procedures, disaster recovery and high performance set up, strategy for scheduled database

health and validation reports and alert and notifications.

Achievements

Architected 50 SQL Servers with databases varying in sizes between 100 GB and 3 terabytes

for new Taxation reporting system. Supported the development environments and set up

processes and procedures for development and operations support

Built performance benchmarks and tuned the capacity and performance design

Set up high availability and high performance using clustering, and mirroring and using SQL

Server versions 2012 and 2014.

2. Phillip Morris US/Australia Oct 2012 to May 2013

Responsibilities (as Senior Database Specialist)

Install, and support SQL Server 2005, 2008 R2, 2012 across Asia Pacific, South America,

Australia/NZ

Build database change processes

SQL upgrade and SQL Migrations to new architecture

Implement high availability, high performance for SQL environments using clustering, log

shipping, mirroring

Support Oracle 10G and 11G database instances

Support SQL Server development and production databases using ITIL techniques

Install reporting server and implement reports and the security

Install Analysis Server, deploy data warehouse, set up ETL and build and deploy reports for

the warehouse

Support SSIS, SSRS and SSAS services, packages and manage migrations, backups

and restore

Troubleshoot the packages and warehouse refresh

Troubleshoot reports failures

Build SQL Server 2008 R2 servers for development, test and production

environments in virtual machines

Achievements

Set up two SQL clustering [active-active] for the high availability

Built and implemented SQL security, audit, and migrations; validate the migration

Migrated development, test, UAT, staging environments to new network and validate

Set up log shipping for data protection for here SQL servers

Production support and maintenance of 500 SQL environments

Upgrade 19 existing SQL Server 2005 to SQL Server 2008

3. AMP Insurance/CSC Melbourne May 2012 to Oct 2012

Responsibilities (as Senior Database Specialist)

Manager AMP AXA SQL environment integration with the AMP main architecture.

Support data migration end to end until and recommend strategy for high availability and

disaster recovery

Design and plan SQL data migration to new architecture

Set up database design, development and support standards

Implement strategy for high availability, high performance for SQL environments

using clustering, log shipping, mirroring

Support SQL Server development and production databases using ITIL techniques

Install SSIS service and deploy SSIS packages and support

Install reporting server and implement reports and the security

Install Analysis Server, deploy data warehouse, set up ETL and build and deploy

reports for the warehouse

Support SSIS, SSRS and SSAS services, packages and manage migrations, backups

and restore

Troubleshoot the packages and warehouse refresh

Build SQL Server 2008 R2 servers for development, test and production

environments in virtual machines

Achievements

Designed a successful strategy for production migration including the disaster recovery

environment with less than one hour down time.

Implemented processes and procedures for design and development, implemented high

availability, high performance and data and audit security for the new integrated environment

Performed database tuning and capacity planning for the new database environments.

4. National Australia Bank/UXC Melbourne May 2010 to May 2012

Responsibilities (as Senior Database Specialist)

Set up database design, development and support standards for SQL Servers and

Oracle Instances

Implement strategy for high availability, high performance for SQL environments

using clustering, log shipping, mirroring

Managing Database Issues, Problems and Changes

Set up SQL migration from one network to another as a business integration process

Build SQL Server 2008 R2 servers for development, test and production

environments in virtual machines

Set up two SQL clustering [active-active] for the high availability

Built and implemented SQL security, audit, and migrations; validate the migration

Achievements

Migrated development, test, UAT, staging environments to new network and validate

Set up and test BCP environments for SQL

Production support and maintenance of 45 SQL environments

Upgrade 19 existing SQL Server 2005 to SQL Server 2008

SQL Server support 85% and Oracle support 15%

5. Westpac Bank/Department of Human Services Melbourne Feb 2010 to May 2010

Responsibilities (as Senior Database Specialist)

Develop database design, development and support plans; support team structure and

implement support processes and procedures

Build virtual environments for SQL database development and production servers

Build 3-node active-passive SQL Server 2008 servers cluster for development, test

and production environments

Set up SQL database design standards

Built SQL performance and capacity monitoring

Achievements

Upgrade 5 existing SQL Server 2005 to SQL Server 2008 R2

Design and developed SSRS reporting for SCOM and SCCM

Set up reporting server and implemented a number of management reports for

reporting on operational data store

Provided development and operations support for a number of SQL Server 2008[95%] &,

SQL Server 2005[5%]

6. PETCO US Sep 2009 to Feb 2010

Responsibilities (as Senior Database Specialist)

Build virtual environments in VM Centre for SQL database development and

production servers

Build SQL Server 2008 servers for development, test and production environments in

virtual machines

Set up SQL clustering [active-active] for the high availability

Set up log shipping for data protection for here SQL servers

Achievements

Production support and maintenance of 15 SQL environments

Upgrade 12 existing SQL Server 2005 to SQL Server 2008

Performed tuning of upgraded SQL environments 2008

Supported SQL Server 2008[50%] &, SQL Server 2005[50%]

7. Department of Infrastructure/Cadability/Synergy Perth Oct 2008 to Sep 2009

Responsibilities (as Senior Database Specialist)

Architecture for BI environment using OLAP and Integration services running 2008

Version Implement virtual SQL 2008 environments for development and production

applications

SQL architectural solution design for data capture and data delivery to multiple clients

and multiple data sources for national and international sports and games events

Production support and maintenance of 25 SQL environments

Upgrade existing SQL Server 2005 to SQL Server 2008

Set up High availability for Integration services and database services 2008 using 4-

node SQL clustering

Implement production support processes and procedures for SQL environments

Implement change and version control in development and design

Implemented SSAS solution for sports event data warehouse

Set up reporting server and implemented a number of management reports

Data Migration from wide variety of data sources into SQL Servers

Achievements

Production support and maintenance of 5 SQL environments

Upgrade a number of existing SQL Server 2005 to SQL Server 2008

Set up change management processes and procedures around database changes

Supported SQL Server 2008[50%] &, SQL Server 2005[50%]

8. Medibank Insurance Company Melbourne Feb 2008 to Oct 2008

Responsibilities (as Senior Database Specialist)

Built SQL Audit and Security strategy, implement SQL audit and security

Migrate five SQL environments from SQL Server 2000 to SQL Server 2005

Implemented virtual environments and configured high availability solutions using

clustering, replication, distributed SQL Servers 2005 and 2008

Responsible for managing development and production database support, implement

database maintenance and management support processes and procedures

Responsible for database design reviews and recommendations

Set up peer replications, backup and DR strategy

Implemented SQL Server design, development and production standards

Migration from SQL Server 2000, 2005 to SQL Server 2008 environment for business

transformation project.

Achievements

Did extensive documentation of SQL standards, processes and procedures for

operational and development database teams

Upgrade 34 Medibank SQL Server 2000 environments to SQL Server 2005 and apply

service packs and hot fixes as appropriate

Implement clustering of SQL Server 2005 for high availability with SAN

environment in 3 SQL instances

Implemented database replications including transactional/merge, log shipping and

peer replication for 2 SQL environments

Supported production and development environments for SQL Servers, Analysis

server, SQL Reporting server

Build SSIS and DTS packages for data migration and other business needs

Implement High availability, SQL clustering, capacity planning, and performance

management

SQL Server 2005[80%] &, Oracle 10g [10%] & Sybase 12.5.2[10%] and Windows

2003 & UNIX

9. IBM/Telstra Melbourne Oct 2007 to Feb 2008

Responsibilities (as Senior Database Specialist)

Migrate twelve SQL environments from SQL Server 7, 2000 to SQL Server 2005

Set up backup and DR strategy

Implement scalability using active-active clustering and high availability using active-

passive fail-over clustering in SAN environment

Implement SQL Server design and development standards

Implement standard processes and procedures around database change, versioning

and release

Support framework for development, operational database environments including

support processes, escalation procedures, backups, data integrity, data security, high

availability, Disaster Recovery

Support developers with database design, development, and migration using change

and release processes

Manage long term and short term database management goals,

Achievements

Supported production and development environments for SQL Servers, Analysis

server, SQL Reporting server

Implemented and supported performance tuning and database maintenance tasks

Implemented database policies and procedures

Managed database support related Issues, problems, risks and execute action items

Developed database release and support procedures

Developed strategies for High availability, SQL clustering, RAC, capacity planning,

performance management

Upgraded 14 Telstra SQL Server 2000 environments to SQL Server 2005

Implemented a SQL server 2005 peer replication between mobile technician tool kits to

Central database environments

SQL Server 2005[80%] &, Oracle 10g [10%] & Sybase 12.5.2[10%] and Windows 2003 &

UNIX

10. Visy Industries Melbourne Sep 2008 to Oct 2007

Responsibilities (as Senior Database Manager)

Database Manager responsible for development and operational support of all SQL Servers,

Oracle Instances and Sybase servers including the replications, high availability aspects,

processes and procedures

Achievements

Supported large SQL Server 2005, Oracle 10G and Sybase 12.5.2 development and

production database environments

Managed database support related Issues, problems, risks and execute action items

Built and configured Oracle 10G RAC and SQL Server 2005 database environments

with terabyte databases. This is implemented at multiple sites

Implemented database change management and release processes and procedures

Developed database production and support procedures and development framework

Built database development and design standards

Implemented high availability using SQL clustering

Developed database availability, security and integrity strategies

Built and upgraded SQL database servers, set up clustering, transactional and peer

replications, log shipping, backup and DR strategy

Installed and configured Reporting server and designed and implemented web based

Reports

Supported production and development environments for SQL Servers, Analysis

server, SQL Reporting server

SQL Server 2005[40%] &, Oracle 10g [40%] & SQL Server 2008 trial [20%] and Windows

2003 & UNIX

11. Telstra/Brightstar/Tennix/Vignette/PMP/NewCrest Melbourne May 2005 to Sep 2006

Responsibilities (as Senior Database Specialist)

Database Support for clustered SQL Server 2005 database environments with terabyte

databases. Six Asia Pacific locations

Implemented Clustering, replication and log shipping for high availability and

business continuity planning

Build and upgraded SQL database servers, set up clustering

Installed and configured Reporting server and designed and implemented web based

Reports

Implemented OLAP services, designed and implemented cubes

Build database servers, support database operations

Audit security, operational assessment testing

Achievements

Project manage migration of application from Oracle 9i to SQL Server 2005

Extensively worked with processes and procedures for issues, problem, change and

release management

Built high availability and high performance SQL architecture

SQL Server 2005[90%] &, Oracle 10g [10%] & Windows 2003 & UNIX

Did database Support for SQL Server 2000 and 2005 databases

Developed database production and support procedures

Did development and production support [50%] and development [30%] and database

design [20%] for 500+ databases

Implemented SQL Servers and Oracle servers

Responsible for capacity planning, performance management

Developed database availability, security and integrity strategies

Upgraded 14 SQL Server 2000 environments to SQL Server 2005

Upgrade and configure SQL Server 2005 and Oracle 10g

SQL Server 2000[30%] & Sybase 12.5 [10%] & Oracle 9i, 10g [60%] & Windows 2003 &

Sun Solaris 2.6, RS6000

12. Redrock/UXC/Ausdoc/DOE/DOI/NZHB Melbourne Feb 2004 to May 2005

Responsibilities (as Senior Database Specialist)

Provide mentoring to Bas on new features of SQL Server technologies

Develop SQL Server processes and procedures, scoping analysis for the clients

Provide architectural advices on the database infrastructure

Build high availability and high performance for the database environments for the clients.

Provide operations support for te databases

Achievements

Migrated five applications from 2000 to SQL Server 2005

Delivered training lectures in SQL Server 2005

Set up database support roster, scheduling database resources for projects

Implemented Proof Of Concept for DHS sub ambulatory case SQL environment using

XML technology for transactions across multiple sites of health care, hospitals and central

systems

Built a replication environment for Meyer

Build database design and development environments for Ausdoc

SQL Server 2000 [60%], Oracle 7, 8i [20%], Sun Solaris 10 & IBM RS6000

13. HP Database Services/ATO Melbourne Feb 2003 to Feb

2004

Responsibilities (as Senior Database Specialist)

Set up database design framework across SQL Server and Oracle database environments for

multiple clients

Subject Matter Expert for SQL Server 2000 and Oracle 9i and provided mentoring for

the DBAs

Set up change and release processes and procedures for database migration and

changes

Achievements

Provided opera ions and development support for the database environments

Implemented change and deployment processes for te database environments

Set up Remedy and Radix issues and problem management framework

SQL Server 6.5, 7, 2000 [20%] & Sybase 11.9.2, 12.5[40%] & Oracle 7, 8i, 9i [40%] &

Windows 2000 & UNIX Aix & Sun Solaris

14. Deloitte Consulting Melbourne Jan 2002 to Feb 2003

Responsibilities (as Senior Database Project Manager)

Database Manager and responsible for database development, infrastructural decisions, expert

guidance for the multiple clients

Responsible for the change and deployment processes, disaster recovery architecture and high

availability

Responsible for issues and problem management for the database environments

Achievements

Upgrading 65 Telstra applications to SQL Server 2000 and Windows 2000 Server

Upgrade Oracle 8i databases to Oracle 9i

Set up database design framework across SQL Server and Oracle database

environments

Subject Matter Expert for SQL Server 2000 and Oracle 9i

Installed and built high availability solution for Telstra

Built analysis server and data load strategy and set up a data warehouse and web

based reporting system

Mentoring DBA resources, develop SQL development environment, development

methodology

Responsible for Database Standards, design, development, and support

Responsible for configuration, change and release management

SQL Server 6.5, 7, 2000 [60%] & Oracle 7, 8i [40%] & Windows 2000 & UNIX Aix & Sun

Solaris

15. Norwitch Union Database Services Melbourne Oct 2001 to Jan

2002

Responsibilities (as Senior Database Specialist)

Database Stream Lead responsible for the support of the existing database environments for

high performance and high availability. Responsible for change, issues and problem

management

Responsible for providing architectural and scoping expertise to the clients

Achievements

Set up database development and production environments for a large Sybase 11.9.2

and SQL Server 2000

Build strategy and scripts to migrate data from SQL Server 7 to Sybase 11.9.2

environment

Provided support for the SQL and Sybase servers production environments

SQL Server 7 [50%] and Sybase 11.9.2 [50%] & Windows NT 4; Windows 2000 & Unix Sun

Solaris 2.7

16. CSC Australia/BHP Billiton/AMP Melbourne Dec 2000 to Oct

2001

Responsibilities (as Senior Database Specialist)

Database Stream lead responsible for the operational readiness of the database environments

Responsible for the change, problem and issues management related to the database

environments

Responsible for recommending upgrade paths, architectural decisions

Responsible for data transformation and loading scripts involving a large number of

different types of data sources including csv files, text files, Oracle/Sybase/Access databases

Responsible for setting up Oracle 8i database instances and the SQL interfaces for a

vendor management system in AMP

Responsible for Database Production Support for a number of Oracle 8i and Sybase

11.9.2 databases

Achievements

Developed a database support strategy including design, development and release standards

and procedures for Oracle 8, Sybase 11.9.2 and SQL Server 2000

Provided operational support for the SQL and Oracle databases

SQL Server 6.5 & 7 [50%] and Oracle 7 [50%] & Windows NT 4; Windows 2000 & Unix Aix

4.3

17. United Energy Melbourne May 1999 to Dec 2000

Responsibilities (as Senior Database Manager)

Database manager responsible for the database infrastructure, upgrade recommendations, and

service level agreements

Responsible for setting up and supporting database operations framework, design and

development, performance and availability

Set up change and deployment processes and procedures and the disaster recovery processes

Customer relationship management

Service Level Agreements for database support with as number of interfaces

Set up database development environments

Achievements

Implemented Database design standards, change processes and procedures

Managed database production support roster

Monitor service level and recommend changes to ensure KPIs are met

Environments

Resolved issues and problems to the customer expectation

Provided customer satisfaction to the desired level

Managed

SQL Server 30% +DB2 30%+Oracle 40%

18. Phillip Morris/National Australia Bank Melbourne Aug 1997 to May 1999

Responsibilities (as Senior Database Specialist)

DBA and development, SQL Server design, database backups and database production

support

Achievements

Provided database production support

Resolved issues and managed problems as per customer satisfaction

Build SQL and Oracle instances and configured

Provided performance tuning

Oracle 60% SQL Server 20% Sybase 20%

SQL Server 6.5, Sybase 11.9.2

19. Wellington City Council/Wellington Port Melbourne Aug 1994 to Aug

1997

Responsibilities (as Database Specialist)

DBA and development, SQL Server design, database backups and database production

support

Achievements

Provided database production support

Resolved issues and managed problems as per customer satisfaction

Build SQL and Oracle instances and configured

Provided performance tuning

SQL Server 6.5, and UNIX

Qualifications

Institute Degree Year Subject

IIT Chennai PhD 1982 Database Development

Training

PRINCE2 Certified Project Management Practitioner

SQL Server 2008 Trained

SQL Server 2005 Trained and trainer

ITIL/CMM trained in Deloitte Consulting Trained in ClearCase

Contact this candidate