We provide IT Staff Augmentation Services!

Sql Developer Resume

NJ

SUMMARY

  • MCITP-Certified & Expert in MS SQL Server 2014/2012/2008 R2 Database Administration, Multi-Server Administration, Policy-Based Management, Security Enhancement, Central Management Servers (Production, Test, Train and Development environments) including Installations and Upgrades, Physical and Logical Data Modeling, Implementing Data Integrity, Schemas, Performance Tuning, Disaster Recovery, Database Maintenance, Data Migration and Scrubbing, Cross-platform Connectivity, Query and Stored Procedure Tuning and Optimization, Coding Triggers and SP, Security Implementation, Replication, Fail-over Clustering, Configuring SQL Servers, and setup Databases options, Capacity Planning, Data Transfer using DTS and BCP, Blocking and Deadlocking, Log Shipping for Disaster Recovery, DBCC checks, Database storage specifications, Remote Administration of the databases and various other areas like MDS, ODS, DW.
  • Certified MySQL, Sybase, Oracle Database Administrator with over 20 years of industry experience, all in Unix with RDBMS, out of which 15 years spent exclusively on Sybase/MSSQL/MySQL/Oracle & Replication Servers (MSA), Stock Securities Allotment, Transfers, Merchant Banking Services, Project Advisory Services, Marketing of Financial Products, Retail Finance and other financial services like Fixed Deposits, Asset Finance and Custodial Services, Insurance etc.
  • Experienced in entire system life Cycle including Shell Scripting, Perl Scripting, System Analysis, Design, Programming, Testing, Debugging and Implementation, user supports and maintenance of client/server based Sybase, Oracle and Replication applications also.
  • Strong experience in Performance Tuning, Installations of Sybase, Oracle & Replication Servers, query optimization, and database consistency monitoring, disaster recovery in Sybase, Oracle, Replication environment and Troubleshooting the Production Replication Servers and Production Databases Supporting by 24/7 and Weekly by On-Calls.

SKILLS

Databases: MS-SQL 2014/2012/2008 R2/sql 2008/2005/2000 , HAMS SQL Replication, Data Mirror, Log shipping, Reporting Servers, Analysis servers, Sybase 4.9/10/11.3.1/ 11.5.1/ 11.9.2/12.0/12.5 /12.5.2/15 , Oracle 8.8i,9i,10G and 11g, Sybase IQ, Replication Server 11.5/12/15, Mysql v5/5.1.

Operating System: Windows 2008 R2/w2003, HP-UX 10.20,11, Sun Solaris 2.6/2.7/2.8, SCO-UNIX, XENIX, AIX,MS-DOS, Novell v4.1.

Language: C, C++, SQL, PL/SQL, COBOL, FoxPro, and Dbase.

Applications: TCP/IP, NIS, DHCP, FTP, VSAT, Netscape, HTML, Internet Explorer, NIS, NFS, DNS, DFS, AFS, UFS, LOFS, HFS, JFS, CDFS, TELNET, PING, FBACKUP, SBACKUP, NWBACKUP, MS-Office, NWRECOVER, SAM, Shell, Sysadm, AWK, SED, Raid, X-Windows, Admintool, DBartisan, LVM, OLAP, ODBC, OLE-DB, DTS, ADO, DCOM, iis, XML. MS Office 2K & 2003, Visio2003, MS Outlook 2003,IIS, RT, BMC(Magic),TSM (TDPSQL),CMS , .

GUI: PowerBuilder 10, VisualBasic 11, Developer 2000, Sybase central, DBA disk top, DB Artisan, SQL Manager, Rapid SQL, SQL Loader, Informatica, Business Objects, BMC Patrol KM, Oracle Advance Queuing, sql*net, xlnet, spotlight.citrix, Backoffice, Toad for MS SQL, MySQL, Oracle.

Hardware: Compaq, Digital, Sun Enterprise E15K/E10K/ 6500/5500/4500 , HP-9000, E10K, V, D, N, K-Class Servers, PC’s, 3Com, Routers, Hubs and Switches, Quintus Desktop v5.1.0.

EXPERIENCE

Confidentyial

Production Sr. DBA OPS TEAM LEAD.

Responsible for maintenance of User Databases in Production, Test, Train and development environment on MS SQL Server 2014/2012/ 2008 R2/ 2008/2005/2000 , SQL Replication Server, SQL Log shipping (HA), Data Mirror, SQL Reporting Servers, SQL Integration, SQL Notifications. Sybase 15/12x, MySQL 5.6/5.1, Supporting and maintaining production servers more than 4000 Servers, 20K databases with max 19TB db.’s managing, Support by 24/7, and On-call Rotation.

Duties

  • Experience in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 2014/2012/2008 R2/ 2008/2005/2000 in Production, Staging, Test, Development, Training, Log Shipping, Data Mirror, Replication (MSA) & Cluster Server Environments, Alwayson, Data collection, MDS.
  • Installation, Maintenance and Troubleshooting of Production ASE12.x/15, Support by 24/7 & on-calls.
  • Maintained & Migration of Databases in Production environment on HP-UX/SUN/AIX/NT and Sybase ASE & Replication12.6/15, MSSQL 2014/2012/2008 R2/2K5/2K,
  • Expert knowledge of Sybase Replication Server (12.6/15) including deployment of different replication topologies (warm-standby, bi-directional replication etc.), replication performance and tuning too.
  • Experience in installation, upgrade, patching and configuration of MS SQL Server 2014/2012/2008 R2/ 2008/2005/2000 and databases in clustered and non-clustered environments.
  • Re-engineering high availability Database Sybase ASE, Mysql, SQL servers and Remediate servers. Implement policies, db objects and best practices.
  • Experience in Performance Tuning, Query Optimization using various SQL Server Commands, sql profiler, MDS (Implementation of Master Data Management), DW, ODS and DTA (Database Tuning Advisor) .
  • Comprehensive knowledge in providing suggestions of using best RAID Technologies based on application requirement (vmax and cx). Cloud aws EC2/RDS, cloud Rackspace, cloud go-daddy and cloud soft layer.
  • Experience in Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
  • Working with IT Operations team on infrastructure, optimization and management Data Center.
  • Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional in SQL Server 2014/2012/2008 R2/ 2008/2005/2000 environment and TB’s data replication.
  • Experience in using tools like SQL Profiler, Active Monitor, Windows Performance Monitoring utility and performance counters for monitoring and Tuning Sybase, MySQL, MS SQL Server 2014/2012/ 2008/2005/2000 Performance, Idera Diagnostic manager, Quest Spotlight and NetIQ, catkin, nagios, bmc patrol.
  • Experience in installation and configuration of Cluster SQL Server in Active/Passive, Active/Active/Active/passive in SQL Server 2014/2012/2008 R2/2005 and Implementing Data warehouse sql.
  • Experience in sql server 2012 AlwaysON implementation and maintaining a high availability.
  • Experience in SQL Server Reporting Services (SSRS) 2014/2012/2008 R 2/2005/2000.
  • Experience in Central Management Server setup and Manage, Implement Policy-Based Management and Multi-Server Administration, Performance Data Collection, Resource Management and Troubleshooting Enhancements, Security Enhancements, Management Implications of new futures, Implement Scalability Enhancements on sql server 2014/2012/2008 R2.
  • Installation, Maintenance and Troubleshooting of Production, Semi-production, Development Sybase, MySQL, MSSQL Cluster, MSSQL Reporting servers , MSSQL Analysis services, MSSQL Integration, Log shipping, DTS, Replication Servers prod, test, Train, Prod Analytic, SSRS.SSIS,SSAS,IIS and development SQL Servers.
  • Handling various databases ranges up to 12000 TBS’s SAN Environments & VLDB.
  • Managing Operation & Engineering dba teams of 40. Attending daily Incidents, Change management, Monthly Maintenance, RCA and Build servers, Manage Infrastructure Services, Storage management and capacity planning and SLA’s etc.,.

Environment: Sybase 15/12.5, MySQL 5.6/5.1/5.0, percona MySQL 5.8/5.6/5.1/5.0 , MS-SQL Server 2014/2012/2008 R2/ 2008/2005/2000 /7, (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), and Data Mining, Replication (MSA) and log shipping (HA), Cloud Amazon EC2/RDS, cloud Rackspace, cloud go-daddy and cloud soft layer.

Confidentyial

Production Sr. Sybase, MSSql, MySQL DBA, MTV NETWORKS Data Center, NJ.

Responsible for maintenance of User Databases in Production environment on MS SQL Server MS-SQL 2008R2 / / 2008/2005/2000 , SQL Replication Server, SQL Log shipping (HA), Data Mirror, SQL Reporting Servers, SQL Integration, SQL Notifications, MySQL 5.1/5.0, Sybase ASE 11.5.1 /12.0/12.5 /12.5.2/15 , Oracle 8/8i/ 9i/10G/11g. Supporting and maintaining production servers more than 200 Servers, Support by 24/7, and On-call Rotation.

Duties

  • Experience in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 2008 R2/ 2008/2005/2000 /7.0/6.5 in Production, Staging, Test, Development, qa, uat, Log Shipping, Data Mirror, Replication & Cluster Server Environments.
  • Experience in installation, upgrade, patching and configuration of MS SQL Server 2008 R2/ 2008/2005/2000 and databases in clustered and non-clustered environments.
  • Experience in Performance Tuning, Query Optimization using various SQL Server Commands, sql profiler and DTA (Database Tuning Advisor) .
  • Comprehensive knowledge in providing suggestions of using best RAID Technologies based on application requirement.
  • Experience in Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
  • Experience in migration of Data from Excel, Flat file, Sybase, Oracle, MySQL to MS SQL Server by using BCP, DTS utility and SSIS packages, sqlcmd.
  • Experience with SQL Server 2008 R2/ 2008/2005/2000 , DDL/DML Triggers, Database Mirroring, Log shipping, Replication (HA), Migration, Upgrading and sql patching.
  • Designing and documenting of SQL Server Strategies and plans for DR, Change control management and security policies and policy base management.
  • Working with IT Operations team on infrastructure, optimization and management Data Center.
  • Creation and maintenance of databases, creating roles and managing user and sql server level permissions.
  • Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, Database Objects authorization, DTS,ETL using DTS(SSIS), Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors, Triggers and more.
  • Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional in SQL Server 2008/2005/2000 environment.
  • Experience in using tools like SQL Profiler, Active Monitor, Windows Performance Monitoring utility and performance counters for monitoring and Tuning MS SQL Server 2008/2005/2000 Performance, Idera Diagnostic manager, Quest Spotlight and NetIQ, catkin, nagios, bmc patrol.
  • Expert in using Third Party backup solutions for MS SQL Server 2008 R2/ 2008/2005/2000 like Tivoli TDPSQL.
  • Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting query performance and MS SQL server 2008/2005/2000 bottle necks including Network Traffic, Hardware usage and Blocking.
  • Experience in installation and configuration of Cluster SQL Server in Active/Passive, Active/Active/Active/passive in SQL Server 2008/2005.
  • Experience in SQL Server Reporting Services (SSRS) 2008/2005/2000 .
  • Expert in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, and DTS.
  • Experienced in managing systems and staff in high-availability environments across multiple data centers in compliance with Sarbanes-Oxley and other regulations.
  • Experience in working with Windows 2008/2003/2000 Enterprise Server and Windows NT Server - Installation and Administration, MOSS, Share point, biz talk, Microsoft Dynamics etc.,
  • Installation, Maintenance and Troubleshooting of Production, Semi-production, Development MSSQL Cluster, MSSQL Reporting servers , MSSQL Analysis services, MSSQL Integration, Log shipping, DTS, Replication Servers nearly 130 prod and 70 development SQL Servers.
  • Expert in MS SQL Server 2005/2008, including SSIS, Analysis Services and Reporting Services. Knowledge of ETL using Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), and Data Mining, Replication and log shipping (HA).
  • Enabled new SQL 2000/2005/2008 faster string search feature, Full Text Search Service, Filesteam searches for character based data in SQL Server tables.
  • Monitor the server and the database to trace engine process events using SQL Server Profiler. Storing data in TRACE FILE or Into Tables for later Analysis 2008/2005/2000 .
  • Understanding developer issues, tuning SQL, writing push down queries in federated database environment optimum data access techniques, Stored Procedures, debug, trouble-shooting and resolving their issues
  • Problem resolution based on SLAs, Service Call, and Change Management, Problem Management, Daily jobs Status reports using (BMC) Magic application & RT (Request Tracker).
  • Experience in monitoring and tuning multiple databases using MS-SQL server Administration tools (MMC).
  • Experience in Advanced technologies like SQLXML, Open XML, For XML, XDR Views, XSD Schemas in SQL server to import and export the Data in XML format with the help of IIS Support in SQL Server.
  • Involved in IIS Administration to create Web Sites, Virtual Directories and Assigning Authentications for web Sites.
  • Manage security and access permissions, handle database performance issues, space management and storage issues, manage the rollout and support of applications, and interface regularly with developers.
  • Migration from Mysql, Oracle, Sybase to MSSQL & Oracle servers and setup data mirrors, VLDB, Clustering.
  • Configuring & Tuning Databases on the Solaris, HP, Linux Platforms (Production MySQL, Sybase, Oracle, Replication).
  • MySQL5.0,5.1 Installation and administration and Certified MySQL dba with 95%.
  • Handling various databases ranges upto 18 TBS’s RAC & SAN Environments.

Environment: MS-SQL Server 2008 R2/ 2008/2005/2000 /7.0/6.5, MySQL v5.1/5.0, TSM v6.1 (TDPSQL), BMC Magic(change management), R T (Request Tracker), Sybase SQL Server 11.5.1/ 11.9.2/12.0/12.5 /12.5.2/15 , Replication Servers 11.5/12/12.5/15 , HP-UX 10.20/11 , EMC, Sun Solaris on E15K/E10K’/6500’s 2.7/2.8/2.9, AIX 4.1.6, NT 4, WIN 2K,2003,2008, Oracle 8/8i/9i/10g,11g, Oracle Streams(replication), UNIX SHELL SCRIPTING, AWK Programming, Embedded SQL, Process Scheduler, and BMC Petrol KM, Sybase Central, SQL Advantage, and ADSM, TSM, MSSQL Backtrack, Citric Servers, Terminal Servers Client,VNC, rclient, DBArtisan, Control-M, Corbin Copy, Avential, Veritas Network Backups, Oracle Advance Queuing, sql*net, xlnet, quest spotlight, SSIS, (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), and Data Mining, Replication and log shipping (HA).

Confidentyial

Production Sr. MSSQL /Sybase/Oracle/Replication DBA,

Responsible for maintenance of User Databases in Production environment on HP-UX, SUN, AIX, NT, MS SQL Server 6.5/7.x/ 2K / 2005, Sybase ASE 11.5.1 /12.0/12.5 , Oracle 8/8i/ 9i , Replication Servers 11.5.1/12.x/12.5. Supporting Accounts Block Buster, Paramount, Person, CBS, Viacom, State Farm, Hosted Services, Sony, Cambles, JPMC, ACE ,JH etc., More than 5000 Servers Production Apps Support by 24/7, On-call Rotation.

  • Handling various databases ranges upto 9TBS’s.

Environment: MS-SQL Server 6.5/7.x/2K/2005/2008, Sybase SQL Server 11.5.1/ 11.9.2/12.0/12.5 , Replication Servers 11.5/12.x, HP-UX 10.20/11 , Oracle 8/8i/9i, SQL *Loader, Sun Solaris on E15K/E10K’/6500’s 2.7/2.8/2.9, AIX 4.1.6, NT 4, WIN 2K, UNIX SHELL SCRIPTING, AWK Programming, Perl programming, Embedded SQL, Process Scheduler, and BMC Petrol KM, Sybase Central, SQL Advantage, and ADSM, TSM, MSSQL Backtrack, Citric Servers, Terminal Servers Client, rclient, DBArtisan, Control-M, Corbin Copy, Avential, Veritas Network Backups, Oracle Advance Queuing, sql*net, xlnet, quest spotlight.

Confidentyial

Sr. Apps SQL/Sybase/HA/Replication DBA,

Responsible for design, support & smooth operation of technical infrastructure for the GE Asset Management Equity Trading Systems and Fixed Income Antares trading systems whose total managed assets is approximately $90billion. And maintenance of User Databases in Production environment on SUN 2.6/2.7/2.8/2.9 Sybase ASE 11.9.2/12.0/12.5 , Oracle 8/8i/9i, SQL Server 7.X / 2000, Replication Servers 12.x, Veritas Clustering, HA, Veritas File System, and WebLogic.

  • MacGregor (Equity) Trading & Portfolio Management System.
  • (Principal Sybase DBA & Unix Systems Administrator).

Environment: Sybase ASE 11.9.2/12.0/12.5 , Sun Solaris 2.6/2.7/2.8 on 6500/4500/3500/3000 ’s, UNIX SHELL SCRIPTING, AWK Programming, Perl programming, Embedded SQL, Replication Servers 12.x, Process Scheduler, and BMC Petrol KM, Sybase Central, SQL Advantage, Oracle 8,8i, 9i, SQL *Loader, SQL Server 7.X/2000 and Veritas Network Backups, DBArtisan, Veritas Cluster Server, Veritas File Systems, WebLogic, iplanet servers, Oracle Advance Queuing, sql*net, xlnet, quest spotlight.

Confidentyial

Sr. Apps MSSQl/Sybase/Oracle/SQL/Replication DBA

Responsible for maintenance of User Databases in Production environment on HP-UX 10.20/SUN 8, Sybase ASE 11.5.1 /12.0/12.5 , Oracle 8,8i, 9i SQL Server 7.X, Replication Servers 11.5.1/12.x.

Environment: Sybase SQL Server 11.5.1/12.0 , HP-UX 10.20 N4000’s & D310’s, Sun Solaris 2.7/2.8 on E15K/E10K’/6500’s, UNIX SHELL SCRIPTING, AWK Programming, Perl programming, Embedded SQL, Replication Servers 11.5, Process Scheduler, and BMC Petrol KM, Sybase Central, SQL Advantage, Oracle 8,8i, 9i, SQL *Loader, SQL Server 7.X and Veritas Network Backups, Oracle Advance Queuing, sql*net, xlnet, quest spotlight.

Confidentyial

Production Sr.SQL/Sybase/Oracle/Replication DBA

Environment: Sybase ASE 11.9.2/12.x, Embedded SQL, Replication Servers 11.5/12.x, Oracle 8I, SQL Loader, HP-UX 10.20/11, Sun Solaris 2.6/2.7/2.8, SQL Backtrack, Perl, AWK, Shell Scripting, Maestro Scheduler, BMC Petrol KM, Remedy Support, Production Databases/Systems Supporting24/7, Pager Rotation, and On-calls by weekly, Oracle Advance Queuing, sql*net, xlnet, quest spotlight.

Confidentyial

Sr. Sybase Administrator

Responsible for maintenance of User Databases in Production environment and Disk Mirroring environment on HP-UX 10.20, Sybase Adaptive Server 11.9.2, SQR, People soft 7.5 and Dbartisan.

Environment HP-9000, IBM PC's, Gateway2000 PC's, Oracle 7.3/8.x, SYBASE SQL SERVER 11.9.2 & 11.5.1, HP-UX 10.20,UNIX SHELL SCRIPTING, AWK Programming, Transact-SQL, Sybase Open Client DB library, Dbartisan, Sybase Central, Rapid Sql, DBA desktop, Oracle Advance Queuing, sql*net, xlnet, quest spotlight.

EDUCATION

  • Certified Sybase 12.5, PB, VB.
  • Certified Training Oracle 10G and Oracle Streams.
  • Sun Microsystems Certified MySQL DBA v5.0.
  • MCITP-sql server 2008.

Hire Now