We provide IT Staff Augmentation Services!

Sr Dba Resume

Richfield Minnesota, UsA

SUMMARY

Sr Manager DATABASE I/O/SYSTEM ADMINSTRATOR with 16+ years of experience with the main focus being, Mysql 5.0,6.0, DB2 UDB 9.1 (ESE)/EEE databases, SAP/BASIS,MS - SQL SERVER 2012, 2008,2005,2000, Sybase, ORACLE 8i,9i,10g,11g,Mysql5.0, RAC10g, databases Big DATA (HADOOP). Other expertise includes Oracle, Microsoft Transaction Server, MSCS and OLAP running on UNIX (Solaris) 8.2 AIX 5.3,5.5,Z/OS and NT, Windows 2003 Possesses strong knowledge and experience in Database Administration, design, installation, configuration, tuning, performance monitoring, Database Development, T-SQL, DDL, DML writing, optimizing Stored Procedures and Triggers. Designed star schema and snow flake schemas with respect to data warehousing physical and logical Database Design, Data modeling - E/R modeling, Dimensional Modeling. Possess good communication skills and comfortable in working in team or individually problem solving skills.

TECHNICAL SKILLSRDBMS: DB2 / UDB EE/ EEE (7.1), DB2 5.0 for OS/390, ES9000 SQL Server 2008,2005,2000, MS-SQL Server 2012, 2008 R2,2005,2000,6.5 & 7.0, Sybase 11.x, Oracle 7.x, 8.x, 9i,10g,RAC10g,11i Database Server, Application Server Microsoft Transaction Server (MTS 2.0), IIS (4.0),Microsoft Share point server 2003, Informix MS Cluster Server (1.0), OLTP, Web logic server 7.0, Web Sphere Server 4.0, MS-Access,

GUI Tools: Power Designer, Erwin 6.0, DB-Artisan 8.0, MS-SQL Enterprise Manager, Sybase Enterprise Manager, Oracle Enterprise Manager, and Desktop DBA, Platinum DBA Tool, SAS, ETL INFORMATICA POWER CENTER 6.1.Trillum Software 7.0, Cognos,OMWB Reporting Tool, DMXPRESS TOOL 5.O,DBUNIT, SSIS, BMC Tools.

Quest Spotlight Quest Central, BMC SQL Backtrack, TOAD 4.5, Install Shield 10.5, AbInitio, Landesk Management suite 9.0, SEP 12.1:

Operating Systems: Windows NT 4.0,Windows 2000,2008.2012,RHEL/CentOS Linux/Windows 7/Windows server 2008, Advanced Server, SUN Solaris 2.5.1 & 2.6, Digital UNIX 4.x, HP-UX, AIX 5.3, Linux 7.0, Windows95/98, Windows XP, Novell 6.0. MVS OS/390, MVS/ESA, Linux,AS/400, DB2 Z/OS

Network Knowledge: Routers, Switches, Firewalls, SNMP, DNS, NFS, CIFS, DHCP(NISPOM), VMWARE, Samba, infrastructure services (DNS/DHCP), authentification services (LDAP/Kerberos), host-based firewalls (IPTables), and network switches and equipment.

Languages: UNIX Shell Scripting, Bash Scripts PL/SQL, SQL* PLUS, T-SQL, Basic, COBOL, JCL

CRM: Siebel 7.5.7.1, 2000

STORAGES: EMC,IBM,HP,NETAPPS

SAP Products: SAP NetWeaver (Basis), SAP R/3 Enterprise (4.7, 4.6,), ECC 5.0, 6.0,

PROFESSIONAL EXPERIENCE

WIPRO Technologies LTD FT Manager, IT Databases

Confidential Richfield Minnesota. USA

Working on Transition all the Databases SQL SERVER,ORACLE, DB2, Mysql, Cache on Widows Unix/Linux,AS400,Mainframe.

  • Managing all the Windows, MS-SQL SERVER databases2000, 2005, 2008R2,2012 EE,SE,Oracle 10g,11g, Mysql 5.5,Cache, Sybase
  • Monitoring all the Applications and Databases Deployments
  • Co-coordinating all the Databases Migrations for Various Environments
  • Working With Various DBA’S and Application Teams
  • Delivering all the Projects and Maintenance Various Application and Databases
  • Planning all the Infrastructure for Various Databases MS-SQL SERVERS,Mysql,Oracle,RAC
  • worked on Oracle database Performance using Oracle Tools
  • Managing and implementing all the Backups and Recoveries
  • Managing and Monitoring all the Productions servers

Confidential, FT Consultant

Sr DBA/System Architect

Installation, Design, Upgrades, Patches, SQL SERVER 2000, 2005, 2008, R2,2012 EE,SE, Windows 2000, 2003,2008, Epic Cache’

  • Migration SQL SERVER FROM 2000 TO 2005, 2008 R2,2012 EE,SE
  • Migration SQL SERVER 2005 to SQL SERVER 2008 EE /Windows 2003 &2008
  • Successfully updated service Pack SQL 2008, 2008 R2.
  • Monitor all SQL SERVER jobs,Hospital data Systems,Epic, Cache’,EMR,Meditech,Nunance,Dragon
  • Worked with all Device connectivity to hospital networks and integration into EMR’s
  • Worked on Non SAP MS SQL server 2005 security administration
  • Worked on designing and implementing a multi-tenant Service
    Oriented DataBase/System Architecture on Epic cache’ on Linux RHT 5.3. base
  • Worked common word processing, presentation, spreadsheet, and database programs.
  • Worked on EMC-SAN & Different RAIDS Levels, EMC-Clarion CX3,Symmetix DMX
  • Sucessufl Deployment of SW applications and integration into EMR’s
  • Worked on Strong familiarity and hands on wireless solutions and IT requirements in hospitals and EMSWorked on SQL SERVER 2008 Active/Passive Cluster Servers
  • Worked on DATA Vulture Gate for Backups, Recovery
  • Worked on QUEST SPOTLIGHT 8.5,Landesk Management suite 9.0, SEP 12.1
  • Worked on SCOM 2007 Servers &Strong knowledge and experience with Electronic Medical Records EMR

Confidential, Consultant

Dallas Parkway, Dallas, Principal/Database specialist

Installation, Design, Upgrades, Patches, SQL SERVER 2000, 2005, 2008, R2 EE,SE, Windows 2000, 2003,2008

  • Migration SQL SERVER FROM 2000 TO 2005, 2008 EE,SE
  • Migration SQL SERVER 2005 to SQL SERVER 2008 EE /Windows 2003 &2008
  • Successfully updated service Pack SQL 2008, 2008 R2. ORACLE Patches 10G
  • Monitor all SAP Databases, SQL SERVER jobs.
  • Worked on Non SAP MS SQL server 2005 security administration
  • Worked on designing and implementing a multi-tenant Service
    Oriented Data Architecture.
  • Worked on T-SQL Scripting Language SQL SERVER 2000,05,08
  • Worked on SQL SERVER 2008 Active/Active/Passive Cluster Servers
  • Worked on DATA VOLT for Backup, Recovery, SEP 12.1
  • Worked on SCOM 2007 Servers and Hospital data systems,EMR
  • Worked with Device connectivity to hospital networks and integration into EMR’s

Confidential, Broadway CT, Cambridge, MA.

Systems/ Lead Database specialist

Installation, Design, Upgrades, Patches, Mysql 6.0 Oracle 10g, 11g,11i, SQL SERVER 2000, 2005, 2008 EE, Windows 2003,2008,Landesk Mgmt. suites 9.0,SEP 11.0

  • Migration SQL SERVER FROM 2000 TO 2005, 2008 EE
  • Migration Oracle10g to Oracle 11g /Windows 2003 &2008
  • Successfully updated service Pack SQL 2008, ORACLE Patches 10G
  • Monitor all SAP Database, Oracle 10g,/11g SQL SERVER jobs, MySql 6.0,
  • Worked on Non SAP MS SQL server 2005 security administration
  • Worked on designing and implementing a multi-tenant Service
    Oriented Data Architecture.
  • Worked on SQL SERVER 2005 Active/Active Cluster Server Worked on Tivoli Net cool TBSM Suite 4.1.1
  • Worked With Database tools SQL Server 2005 - Integration Services, Analysis Services, Reporting Services (report builder & report designer), Query Analyzer, Enterprise Manager, SQL Profiler, DBCC, DTS, DTExec, DTUtil, OSQL, SQLCmddge
  • Worked on BR TOOLS,SAP Oracle 10g,11g DBA, SAP SQL SERVER 2008 DBA
  • Good understanding on SAP architecture, experienced in SAP installation, using SAP DBACockpit, and navigating SAP with various T-codes and Menus, monitoring SAP application
  • Backup/Recovery using IBM TSM 5.3 7.1 Quest software. Involved 24/7 Production support & Used T-SQL Scripting Language on SQL 2005,2008
  • Worked On 32-Bit and 64-Bit Processor Servers
  • Export/Import data different application using DTS/SSIS PACKAGE & ETL SSAS
  • Worked on Log shipping SQL SERVER 2000,2005,2008
  • Worked on Widows Server & Remote Desk Top
  • Worked on reporting tools - SSRS Report Builder, SSRS Report, Primavera P6 Reporting DATABASE R2 , Installation, Configuration, Scheduled tasks ,and Scripts
  • Worked on with Visio, Erwin and Embarcadero E-R Studio

Confidential, Burlington, MA

Lead DBA

  • Installation, Design, Upgrades, Patches , Mysql, SQL SERVER 2000, 2005, 2008 EE, DB2/UDB 9.1 EE, BMC tools, Unix, Linux
  • Windows 2003,2008/Unix , Linux RED HAT, HP-UX 11.i
  • Migration SQL SERVER FROM 2000 TO 2005, 2008 EE
  • Migration SQL SERVER 2000, MySql 6.0 to Oracle 11g /UNIX using tool OMWB 10.1
  • Successfully updated service Pack SQL 2008, ORACLE Patches 10G
  • Monitor all SAP Database, Oracle 10g,/11g SQL SERVER jobs, MySql 5.0,
  • Worked on Non SAP MS SQL server 2005 security administration
  • Database loading and testing various tool DMXPRESS 5.0, SSIS 2005, 2008, T-SQL
    Oriented Data Architecture.
  • Worked on SQL SERVER 2005 Active/Active Cluster Server
  • Worked With Database tools SQL Server 2005 - Integration Services, Analysis Services, Reporting Services (report builder & report designer), Query Analyzer, Enterprise Manager, SQL Profiler, DBCC, DTS, DTExec, DTUtil, OSQL, SQLCmddge
  • Worked on BR TOOLS,SAP Oracle 10g,11g DBA ,SAP SQL SERVER 2008 DBA
  • Good understanding on SAP architecture, experienced in SAP installation, using SAP DBACockpit, and navigating SAP with various T-codes and Menus, monitoring SAP application
  • Backup/Recovery using IBM TSM 5.3 7.1 Quest software. Involved 24/7 Production support
  • Worked on Excel Graphing PIVOT table for analysis Purpose
  • Export/Import data different application using DTS/SSIS PACKAGE
  • Worked on Log shipping SQL SERVER 2000,2005,2008
  • Worked on Window server & Remote DeskTop
  • Worked on reporting tools - SSRS Report Builder, SSRS Report
    Designer and Crystal Reports Installation &Maintaines
  • Worked on with Visio, Erwin and Embarcadero E-R Studio

Hire Now