Management Sql Server

Inder Singh

******@********.***, **********@*****.***

913-***-**** (O), 913-***-**** (M)

http://www.linkedin.com/in/inderks

[pic]

Business Experience

[pic] Nueterra 02/14- Present

Senior Architect/DBA

V Achieved significant cost saving by simplifying the systems

architecture, implementing best practices for security and stabilized

overall process of data movement from various partner sites to final

destination of reporting for management.

V Provided guidance to team members in order to achieve organization

goals.

V Reviewed existing business model and proposed various alternatives

V Conducted extensive survey with all stakeholders and sites to

understand mix of:-

. Management hierarchy

. Responsibilities of various parties involved

. Mix of technologies and tools being utilized at partner sites and

Nueterra's facility

. Reviewed technical challenges being faced by technical and management

. Communicated with all stake holders as and when what is needed; to bring

everyone on the same page. So that everyone understand the expectations

and role of involved parties as well as timelines about what will be

done, by whom and when the deliverables are due.

V Overcome several technical challenges being faced by all parties'

involved and devised acceptable solutions for all stake holders.

V Redesigned and implemented the overall architecture of the Business

Intelligence System including implementation of highly complex data

integration processes

V Rebuild and redesign logical and physical data model(s)

V Re-purposed various servers

V Brought data from various hospitals and surgical centers; into our

Business Intelligence system for analysis and generate reports helping

management in decision making.

V The Predictive Analytics is helping Management team as they are able to

take lot more robust decisions.

V Continue providing assistance/ guidance to various Nueterra management

associates in order to improve their team's productivity and increase

ROI.

Infrastructure: SQL Server 2012 R2 (also: 2008 R2, 2005 and 2000), Windows

Server 2012 R2, IBM Netezza Appliance (Massive Parallel Processing - Data

warehouse server), InfoSphere Information Server and IBM COGNOS.

[pic] 06/12- 02/2014

Oracle Apps Database Administrator

V Provide production and non-production systems support for various

business critical applications with worldwide user base; applications

including Oracle EBS R12 and EBS 11i, Oracle Transport Management,

Governance Risk Compliance Management, Configuration Control Governor,

COGNOS and OBIEE.

V Assist developers/analysts in identifying and resolving various

performance issues and resolving these issues by re-writing code

efficiently, utilizing indexes, hints, partition tables/indexes,

implementing optimized execution plan for queries, restructuring data

files, database server kernel parameter, database parameters, re-

organize database and rebuild indexes.

V Review and modify logical and physical data models as and when

necessary.

V Upgrade the entire application implementation (application tier, web-

tier and databases).

V Apply applications and database patches for all supported applications

and databases.

V Clone various application environments (including apps tier, web tier

and database tier).

V Change management: Work on migrations from development environment

through production environment.

V Document procedures for work performed including system architecture,

troubleshooting guides, password change procedures, cloning

improvements, system startup and shutdown procedures.

V Work with developers, analysts, project managers, system / network/

security administrators, fellow DBA team members and vendors including

Oracle support to resolve various applications and database issues.

V Manage database security utilizing best practices including utilization

of roles and profiles. Change passwords on quarterly basis for key user

accounts (Apps and database users).

V Implemented Incremental backup (Cumulative and Differential) for

various databases.

V Communicate with user community while resolving issues related to them

and also sending notifications/updates to them for schedule/un-schedule

downtimes.

Infrastructure: Oracle 11g R2 RAC, Oracle EBS R12/ 11i, OEM 12c, Oracle

Enterprise Linux 6, Sun Solaris 10, Toad, Oracle Exadata V2, SQL Server

2008 R2, Windows Server 2008 R2, Dell and HP servers.

[pic] 06/11- 6/12

Senior Database Administrator

V Provided 24X7 production support for various enterprise wide business

critical systems including Oracle / PeopleSoft CRM, FSCM and HCM.

V Provided development support; work with analysts, developers, project

managers and department heads.

V Updated/upgraded RDBMSs, applied patches and resolved technical issues

including performance issues of various SQL Server and Oracle databases.

Infrastructure: Oracle 11g R2, Grid Control 11g, Oracle Enterprise Linux

5, Sun Solaris 10, SQL Server 2008 R2, SQL Server 2005, Windows Server 2008

EE, Toad, Dell and HP servers.

[pic] 02/11- 06/11

Senior Database Administrator (SME)

V Provide subject matter expert services (Oracle DBA/ system architect).

V Utilize Best practices in order to design and implement new database

servers (Oracle 11g).

V Improve system performance of database servers. I was able to improve the

system performance that enabled HNTB to sell the product to various Army

basis in USA.

V Work with developers and systems analysts to migrate data between various

data sources (ETL). I was responsible to develop ETL scripts to import

data based on given conditions in a given format and then load it into

various target databases.

V Generate system health reports and resolve database installation and

configuration issues.

Infrastructure: Oracle 11g R2, Grid Control 11g, Windows Server 2008 EE,

Toad, Dell and HP servers.

[pic] 01/11- 02/11

Senior Database Administrator (SME)

V Upgrade and migrate multiple SQL Server (release 2000 and 2005) databases

from physical servers to SQL Server 2008 clusters hosting various

business critical systems utilizing industry standards and best

practices.

[pic] 08/10-12/10

Senior Database Administrator (SME)

V Provided production and development support and maintain database

availability (24 x 7 x 365) of several hundred databases (OTLP and

Decision Support Systems / Data warehouse systems) under AIX, Solaris,

Linux and Windows environments.

V Upgraded various database servers to latest Oracle database releases.

V Backup/restore of databases utilizing RMAN, Tivoli and data-pump

utilities.

V Refreshed non-production environments from production databases.

V Cloned databases as per requirements.

V Troubleshoot issues and work on performance tuning; utilize Oracle Grid

Control and 3rd party tools including Toad, DBArtisan and several SQL

scripts to review status of the database instances.

V Evaluated, tested and moved customized objects in databases (views,

tables, indexes, synonyms, constraints and packages).

Infrastructure: Oracle 11g/10g/9i, IBM AIX 6.1/5.3, Sun Solaris 10,

Windows Vista, Toad, Tivoli, DBArtisan, IBM, HP, Dell and Sun Servers.

[pic] [pic] [pic] 07/04-08/10

Team Lead/ Senior Database Administrator

V Successfully merged 13 companies information systems into single

trustable IS system for Monsanto.

V Studied and evaluated new technologies and implement the best possible

solution based on requirements of the company as well as agreement

between users of the final solution (hardware and software combined).

V Recommend, develop, document, and enforce best practices including the

disaster recovery solution.

V Offered alternative solutions for various requirements to the top

management.

V Work with team members in order to create project plan(s), get sign-off

from related departments and implement project plans.

V Planned and conducted user acceptance tests and trainings.

V Worked with helpdesk team and work out plan about how to understand and

assist users of the system in case if there is problem with the system

and how to escalate the issue to further level.

V Designed, tested, implemented and managed systems for Utility management

system, billing and various PeopleSoft Enterprise applications.

V Worked with Oracle's PeopleSoft consulting services and Sun Microsystems

teams in order to implement, maintain and upgrade:

< PeopleSoft Financial Supply Chain Management

< PeopleSoft Human Capital Management

< PeopleSoft Enterprise Management

< PeopleSoft Enterprise Portal

V Utilized Quest Data modeler for logical and physical data model (ERDs)

as well as reverse engineer (ERDs) of databases in order to assist

development team.

V Planed and implemented system upgrades (O/A, RDBMS, applications and

storage).

V Prepared implementation plan and contingency plan for supported

applications for moderate to large impact projects of the

organization.

V Provided guidance to developers; in relation to PL/SQL

(customizations, improvement of existing applications).

V Ensured databases were monitored proactively for optimal performance

and the dba team acts quickly to mitigate performance issues.

V Prepare user defined functions, stored procedures, packages and

triggers under Oracle and SQL Server environments.

V Utilized various in built functions (system, mathematical, string,

metadata, security, cursor, configuration, system statistical) while

writing new code and/or managing databases.

V Utilized SSIS (ETL) feature of SQL Server to transfer data between SQL

Server and (replicate changes to Oracle databases and receive data

from Oracle databases).

V Debugged issues and performance tuning utilizing various tools

(PeopleSoft, Microsoft, Oracle and Quest). That included debugging

PeopleCode, Application Engine processes, SQL statements, database

components, configuration of web server, application server and batch

servers etc.).

V Utilized Oracle Diagnostics, Grid control, Quest Performance Analysis,

Quest Spotlight and O/S diagnostics software.

V Set and received notification for various events and jobs on database

servers.

Infrastructure: Oracle 11g/10g/9i (RAC, HAC and standalone servers), SQL

Server 2008/2005/2000, Windows Servers 2008 R2 and 2003 R2, Simpana, Quest

Central, Toad Data Modeler, Oracle Grid Control Infrastructure, PeopleSoft

FSCM 8.x, HCM 8.x, EPM 9, Enterprise Portal 9, AIX 6.1/5.3, Sun Solaris 10

& 9, VMWare, Sun Fire V890s and V1280s

[pic] [pic] [pic] [pic] [pic] [pic] [pic] 05/93-06/04

Team Lead, Senior DBA, Systems Analyst and Developer

V Lead the computerization of Common schedule of Rate (CSR) and Analysis

of Common Schedule of Rates (ACSR). This product was designed to be

used by every state's Government's Public Works Department and several

thousand contracting companies all around the country.

V I was involved from gathering analysis, developed front-end app and

built entire data structure for the application. These systems turned

old contracts bidding system into computer based bill of materials (of

several thousand labor and material items).

V Contractors could create and predict the cost of a hospital and other

construction projects to be built over the time period with inflation

and geographic variables in mind.

V Lead development of Material Management System: Prepare Bills of

Material, Production Plans, and reports modules.

V Worked on multiple CRM, supply chain and data warehouse (business

intelligence) projects at Microsoft.

V Utilized Visio and ERWin for data modeling software in order to

prepare logical and physical data models (ERDs) as well as reverse

engineer existing databases.

V Setup data replication between various SQL Server databases

V Developed and implemented data scrubbing engine utilizing stored

procedure to clean the data first in the staging database after

importing the data from various OLTP systems.

V Prepared hundreds of stored procedures, user defined functions (T-SQL)

and utilized existing functions (date & time, mathematical, string,

metadata and system).

V Lead development efforts and port data from various legacy systems

into SQL Server database for Association of Secondary Teachers of

Ireland and built data warehouse.

V Worked on various projects (complete software development life cycle).

Developed ActiveX controls, front-end and middle tier components.

V Prepared new databases for various PeopleSoft application environments

(dev, test, quality assurance, staging, training and development) in

physical three tiers.

V Server installation (Windows Servers, SQL Server, Oracle, Oracle

Enterprise Manager, Oracle Express Server etc.), 24 x 7 production

support including:

. Apply application patches (for application from Cerner Millennium,

PeopleSoft, PMSI, and Alliance).

Infrastructure: SQL Server 2000/7, Oracle 9i/8i, Sun Solaris 8, Cerner

Millennium, PACS, PMSI, Windows 2000, Windows NT 4, VMS, Visio, Visual

Studio, Web Logic, Tuxedo and Erwin, and PeopleSoft 8.4/ 7.53

Technical Skills

RDBMS Oracle 11g R2/10g/ 9i/ 8i

MS SQL Server (2012 R2/ 2008 R2/ 2005/

2000/7/6.5)

PostgreSQL and IBM DB2

Big Data Hadoop 2.x, Datastax Enerprise (DSE)

Applications Cerner Millennium

AdvantX

Amkai

Meditech

Paragon

PACS

PMSI

Oracle Customer Relation Management (CRM)

Oracle E-Business Suite R12.2.2 and R11i

Oracle/ PeopleSoft 9.x/8.9x:

Financial Supply Chain Management

Enterprise Performance Management

Human Capital Management

Enterprise Portal

Oracle Transportation Management

Oracle Business Intelligence Enterprise Edition

(OBIEE)

Oracle Governance, Risk and Compliance (GRC)

Oracle Configuration Controls Governor (CCG)

Agile scrum

and various Change Management solutions

Servers/ Massive IBM Netezza appliance

Parallel IBM xSystems

Processing IBM Power Server 7xx

Servers Oracle Exadata V2

Oracle Sun Fire V890s/V1280s

HP DLxxx Gx and

Dell Servers

Data modeling Visio, Toad Data Modeler and ERWin

Software Visual Basic, Visual Foxpro, C, NoSQL, PL/SQL and

development T-SQL

Operating Systems Various Linux / UNIX platforms including OEL,

RHL, Ubuntu, Sun Solaris and IBM AIX.

Various MS-Windows Servers (from Rel. NT 4

through Windows Server 2012 R2 )

Virtualization IBM LPARs

MS-Windows virtualization

VMware platform under Linux and Windows O/S

Oracle Solaris partitions

EDUCATION

> Bachelor of Commerce (Math, Computer Science, Management, Statistics,

Financial accountancy, Cost and Management Accounting, Economics,

English) from Punjabi University: 1993

> Honors Diploma in Systems Management (Computer Science), from National

Institute of Information Technology: 1995

Management

> Project Management - Managing IT projects (Project Management Institute)

2006-2007

> People Skills from "The Effective Institute, Inc." This teaches various

skills about people and assist in resolving any issue related with

people. 2001

> ISO 9000 industry standards training (India) 1997

Technical Trainings/Seminars

> HIPAA (Evergreen Hralthhcare)

> Oracle Open World 2014 - Several sessions related to various technologies

and solutions (Cloud Computing, Big Data and Business Intelligence).

> IBM InfoSphere Data Stage Tool (2014)

> IBM Netezza Server (2014)

> IBM DB2 UDB Essentials Part 1 - Fundamentals of DB2 UDB Programming

(USA). 2006

> Oracle 12c RDBMS and Oracle 12c OEM (2013)

> Oracle RUI (2013)

> Oracle EBS 12i installation, patching and cloning (2012)

> Oracle 9i RAC, Kansas City. 2004

> Visual Studio.Net, Palm Springs. 2003

> ASP.Net, Palm Springs. 2003

> SQL Server, Palm Springs. 2003

> Oracle 9i, Bellevue.2002

> PeopleSoft Server Administration, PeopleSoft Database Management Tools,

PeopleSoft Database Upgrade, PeopleSoft Tools, PeopleSoft Tools I version

7.53, from PeopleSoft University, Seattle. 2000-2001

Contact this candidate