Deepak More

Palatine, IL *****. Ph. 847-***-**** (H) 224-***-**** (M)

Email: ac2ec2@r.postjobfree.com

Technical Skills

RDBMS

SQL Server (00 12) x32/64 and Oracle 7--11g

Database Management Tools

OEM, TOAD

Data Model/Development

Visio, CaseStudio, Erwin (4.1.x), PL/T-SQL

SQL Tools

SQL diagnostic mngr. (SQLdm), Idera, Ignite

SQL Server Management Studio

Advanced Features

Cluster, Mirroring, Partitioning, Data Auditing/Compression and Encryption [TDE]

Backup/Replication

LiteSpeed (6.x), Backup Compression, Data Pump, SqlLoader, StandBy/DataGuard, RMAN, Export, Import.

Operating Systems

Windows Server(05-12)x64 Enterprise,

HP-UX (10.xx), Red Hat Linux (2.1.x).

Scripting

KSH, SH, PERL.

Networking

TCP/IP, FTP, NFS, NIS, NTP.

High Availability

RAC, SQL Cluster, Mirroring, Raid Manager.

ETL Tools

Informatica Power Center 5.x.

CRM

Remedy (5.0), Siebel (7.3.8)

Hardware Worked On

Dell PowerEdge 9/10th generation, HP 9000/K100, Sun E 3500/450/250/Ultra.

Storage & SAN

Dell/EMC CX3, Dell PowerVault MD 3000 SAS, Sun A5200, D1000.

Web Servers

WebLogic (8.1 sp3), LDAP (4.x)

Academics

BS in Computer Science

Puné University. Puné, India.

DAC Diploma in Advanced Computing Advanced Computing Training School (CDAC) Puné, India.

Residency Status

Citizen.

Area of Interest

SQL SERVER DBA / Oracle DBA

Data/Enterprise Architect, Data Modeler.

Responsibilities

" Design,

$ Development

: Implementation

4 Maintenance

G User training

Objective

Seeking a challenging opportunity to leverage my data base skills.

Summary

Professional software consultant with OVER twenty plus years of technical and functional experience in all stages of development and implementation. Provided high quality support for the production, test, and development environments by implementing, managing, monitoring and maintaining multiple database servers and databases. Analyzed and studied complex application(s) for the database requirement to proactively design, plan and deploy needed capabilities.

Ability to

Work independently or under only general direction in a fast-paced and flexible environment with tight deadlines and changing priorities.

Effectively troubleshoot system problems by identifying and implementing software or process changes that allow business applications to operate with minimal risk.

Manage multiple issues simultaneously and expectations of management; motivate/collaborate with team members to achieve sustained results.

Implement current/emerging technologies which create value without putting the organization at risk.

Experienced with business process implementation in the design and implementation of systems using “MS SQL-Server” and “Oracle” database management systems and their integration. A good understanding of the entire SDLC process, including specification, documentation and quality assurance. Translated technical database issues, requirements, limitations and parameters for management and staff, to understand business work processes and business impact.

Highlights

Implemented the Project within time and budget. Created detail conceptual Logical & physical database design for enterprise. Defined data strategy process for structured & un-structured data. Excellent understanding and practical experience with SQL language and data modeling.

Provided Technical consultation to the clients having complex and multi-site environment. Did Requirement Gathering, Gap Analysis and Implemented customization through development team. Good working experience in handling large-scale production environment.

Managed the technical team, Reviews the policies & work of the Data Base Administrators. Supported 7x24 “Production”, “Development” & “UAT”.

Ensured compliance with Corporate/Division policies and procedures. Established and maintained high-quality relationships with all levels across the company and with external partners. Provided hands-on analysis and support to ensure data integrity is maintained for all globally-deployed instances.

Worked on Proactive/Reactive Performance Tuning and implementation of advanced Backup/Recovery, Replication, Mirroring and Clusters.

Lead the data migration activities on “SQL-Server” and “Oracle” (which include pre-migration analysis, data migrations and validations).

Implemented, configured, and administrated large-scale MS SQL databases in an E-Commerce environment.

Installed and configured “SQL” server 2008. Upgraded “SQL-05” to “SQL-08” and “SQL server 2000 SP4” databases to “SQL server 2005”.

A strong understanding of MS SQL Server 2005 / 2008 security, compression, partitioning, performance monitoring and optimization techniques, indexes, constraints, transactions, file groups, stored procedures, triggers, cursors, locking, and query tuning.

Projects Summary

7x24 production support for banking, pharmaceutical, software (IT), mobile and manufacturing industries.

Did reverse engineering for legacy database instances to improve performance and to take advantage of new cutting edge technology.

Experience

The True-blue companies Sr. DBA/Architect SQL-Server/Oracle April-12 to Present

Project: TempWorks, Empower Time, Grate Plains, Rosetta, SQL-BI, Corp Databases (51 Months)

Provided 7x24 on call support for multi terabytes, multi server “SQL-server” (05/08/12)/”Oracle” (10g/11g) production clustered databases. Administered multi-Terabyte databases in environments including servers processing more than 20 million transactions per hour, thousands of concurrent processes, partitioned databases, clustered servers, replication, and log shipping.

Designed database architecture for high scalability and query performance optimization. Implemented aggregation processes, table partitioning, data warehouse loads and transformations, data transfers in heterogeneous database environments, and database maintenance plans. Created customized log shipping and other high availability solutions, allowing large database migration between servers with only minutes of downtime.

Developed numerous tools and utilities to automate DBA tasks and processes, including customized database maintenance plans, capacity and performance analysis, trace analysis, security investigations, database space allocation reports and historical trends, automated restoration of hundreds of databases, and scheduled job monitoring. Developed stored procedures for automated PGP encryption and decryption of data files and for secure file transfers through FTP. Designed and developed advanced search systems for major web sites.

Implemented TDE, Consolidated SQL SERVER databases, Migrated 200+ Access databases to the SQL SERVER 2012. Implemented and configured Active/Passive VM, Windows Cluster using Microsoft Windows Server 2012 Datacenter Edition. Also configure BI, SSRS, and SSIS stand-alone SQL VMs for BI Project. Involved in EMC SAN Migration, SQL SERVER Licenses, DR, CISCO ROUTER, Brocade Switch project and implementation.

Baxter Sr. DBA/SQL-Server/Oracle Oct-11 to Mar-12

Project: Various Pharmaceutical Applications. (6 Months)

Performed database administration, design and development of multiple applications deployed by the company on more than 80 Microsoft SQL Servers. Was responsible for DBA support of a mission-critical OLTP system partitioned on 30 Microsoft SQL Servers on a Windows NT network and serving hundreds of users nationwide. Was responsible for DBA support and administration of several decision support systems. Automated DBA routines and data loads, optimized recurring processes. Administered security. Designed Transact-SQL coding standards. Performed database disaster recovery and troubleshooting.

Nuveen Investments Sr. DBA/SQL-Server/Oracle Feb-11 to Sep-11

Project: SimCorp, Portia upgrade. (8 Months)

Provided 7x24 on call support for multi-server “SQL-server” (05/08R2)/”Oracle” (10g/11g) production clustered databases in windows environment. Worked with SimCorp and Porsha team on various aspects of application upgrade. Implemented new SimCorp version in Production. Changed character set of Oracle database, Re configure Oracle backup job and implemented OEM. Evaluated SQL SERVER databases for Performance issue. Implemented process to rebuild fragmented indexes. Evaluated SQL SERVER monitoring tools.

Harris Bank. Chicago, IL Sr. DBA/Architect SQL-Server/Oracle Mar-07 to Jan. 11

Project: Various Banking Applications, Anti Money Laundering (AML) & Check Vision. (47 Months)

Provided 7x24 on call support for multi terabytes, multi server “SQL-server” (00/05/08)/”Oracle” (10g/11g) production clustered databases. Ensured performance, availability and security of multiple databases. Performed daily checks; as part of a predefined routine while supporting the database projects related activities. Did performance monitoring and capacity planning, database installation and configuration, database backup and recovery, patch upgrades and security compliance, audit trail monitoring and database partition. Administered all database objects, including tables, indexes, views, sequences, procedures and packages. Administrated SAN/NAS for over 80 terabytes of storage.

Involved in the architecture, design and development; as well as the tuning of new and established “SQL-server”/”Oracle” databases and related applications. Participated in the definition of the overall delivery strategy of large data initiatives such as data migration and consolidation, data warehousing, data quality, and master data management. Operated as a hands-on data and database subject matter expert when necessary.

Configured database parameters, created prototype designs against logical data models. Defined data repository requirements, data dictionaries and warehousing requirements. Optimized database access, SQL packages and allocates/re-allocates database resources for optimum configuration, performance and cost. Maintained detailed/professional production support and operations documentation. Assisted troubleshooting the market risk and credit risk applications using MS SQL Trace and DBArtisan.

Scheduled and coordinated database maintenance activities including database reorganizations and restructures. Participated in on-call and off hour’s production problem resolution activities. Evaluated all SQL server instances for enhancements design. Developed and maintained databases that interact with third party software applications. Worked on enterprise applications integration efforts; validated associated work products.

Cut hardware and software costs by more than 50% while avoiding the painful compromises associated with traditional database consolidation. Most of the SQL databases are widely deployed x86, running on almost 20% of all x86 servers. Consolidated SQL infrastructure by 4X to 20X using "VMware vSphere".

Implemented and maintained clustering with “four” nodes and MS SQL replication with two nodes. Supported clustering and replication for servers around the world on ten different domains; complied with intricate security and compliance risks inherent with a global financial company. Consolidated SQL Servers with SQL 2005, reducing server count by 30% and saving over $200k in licensing in one year. Reduced database load and improve scalability by implementing partitioning to handle tables with over 300 million rows.

Abbott Labs. (GPRD) Waukegan, IL Sr. DBA/Architect SQL-Server/Oracle Feb-05 to Feb-07

Project: Various Pharmaceutical Applications. (24 Months)

Maintained 100+ SQL-SERVER databases in several gigabytes to terabytes in sizes. Supported applications like ADP, BizTalk, Kronos and Aspect Call Center. Successfully resolved SQL Server problems in conformance with SLAs, which involves connectivity, replication, DTS, SSIS, backup/restore, database corruption, and security.Implemented efficient databases, including specifying physical characteristics, design efficient partitioning and indexes, and mapping database objects to physical storage devices. Lead the design, integration and maintenance of complex “SQL-server” 2000/05 databases. Created logical and physical data models; translated data models into physical database designs.

Provided consultation on strategic direction for database design, development and maintenance. Established strategies and requirements for database backup, recovery, migration and archiving. Analyzed data access, database design for optimal performance. Defined thresholds for database monitoring. Recommended proper hardware and software implementations to improve quality, efficiency and minimize cost. Created and maintained documentation related to the company data warehouse and operational business systems; as per the FDA regulations.

Established strong working relationships with other architects, operations and other technology team members. Supported cross technology process improvement initiatives. Participated in firm-wide Architecture/Engineering working groups, and ensure that the technology organization is aligned to corporate technology directions.

Installed, configured and upgraded existing databases. Monitored and tune mission critical production database for optimal performance. Isolated, diagnosed and restored business operations in a timely fashion. Upgraded “Oracle 9i” databases to 10g. Migrated “SQL” server 2000 SP4 databases to the “SQL” server 2005.

Participated in regional and worldwide projects deployment. Provided technical specifications for application enhancements, customizations and extensions. Conducted research and make recommendations on database products, tools, services, protocols, and standards in support of procurement and development efforts

Performed monitoring and tuning of development, test and production environments including identification and tuning of poor-performing application code and/or database configuration. Identified and automated regular database and application maintenance tasks. Monitored the systems development activities as they relate to the database development effort. Worked with Developers, System and Network administrators in a multinational environment to support and improve system performance and stability. Implemented, coordinated and monitored SQL 2005 Clustering.

AutoDesk. San Rafael, CA Sr. DBA/Architect SQL-Server/Oracle Aug-02 to Jan-05

Project: Remedy application systems & Magellan legacy systems. (31 Months)

Maintained 40+ SQL server instances. This includes multiple databases on 2000 & 2005 having sizes in multi GB. Provided 7/24 on-site, on-call and weekend maintenance support to maintain service levels and to ensure proactive response to alerts or service requests. Installed and configured SQL Server 2005 databases. Set up disk storage layout. Moved tempdb and t_logs to separate locations to improve performance. Set up email send/receive with SQL Server, created backup/recovery strategy, set up replication, automate statistics, and DBCC. Mentored database analysts in database administration activities providing training, exercises, and task supervision.

Defined & maintained the logical enterprise data architecture. Ensure the data model with in the established standard properly supports changes to the requirements. Architect & implemented flexible, high performance database schemas to support "Remedy" application. Designed databases for QA, Test, & Development. Created around 500 tables to support these applications. Supported the development team with ad-hoc data query & manipulation.

Performed changed, released, incident, and problem management activities to support business operations. Maintained proactive health-check operations, service monitoring alerts, and comprehensive configuration documentation for all environments. Performed ad hoc responsibilities and duties as assigned.

Analyzed security patches and performed risk assessment. Engineered SMS packages to deploy those security packages following SDLC process. Maintained and enforced standardized, repeatable, administrative and operational policies and procedures. Monitored all server and system software activity to ensure service availability. Provided skill-set knowledge transfer that ensures necessary cross-training of other staff members. Designed and populated reporting tables, views and stored procedures. Developed data warehouse processes. Worked on large scale data optimization and DTS to SSIS conversions. Maintained Log Shipping, Mirroring and Replication with three nodes.

AirTouch. Walnut Creek, CA DBA SQL-Server/Oracle Sep-00 to July-02

Project: Wireless Fraud Detection System. (FraudPro) (23 Months)

Maintained 30+ SQL-server instances. Provided 7x24 supports for production databases. Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity of the critical production databases. Implemented data models and database designs, data access and table maintenance codes.

Interacted with project managers, developers, BI analysts, end users, and management to enhance, refine and improve the data base operation from a 7x24 availability standpoint. Created and implemented strategies for the future direction of information in the existing data base environment. Designed a divisional enterprise data model to accommodate a new Data Warehouse. Utilized best practices from the industry to set the foundation for the Diagnostics Division's Data Warehouse of the future.

Supported complex data architecture, query and stored procedure development. Provided technical support for scheduled and ad-hoc data migration needs. Improved and maintained databases rollout and upgrades. Supported backups/restores, monitored SQL uptime, designed and maintained DTS packages. Administered and installed SQL Servers 2000, replication and log shipping.

Improved performance of production databases by troubleshooting issues like deadlock, blocking, latency, memory bottlenecks, disk I/O bottlenecks, and CPU bottlenecks Used tools such as SQL Profiler and Performance Monitor to analyze issues to determine root causes. Developed long-term solutions document changes and update defect tracking system.

Wells Fargo Bank. Tempe, AZ DBA SQL-Server/Oracle Oct-98 to Aug-00

Project: Fraud & Claim tracking system. (FACT) (23 Months)

Administered ten servers in 7x24 production environment. Average database size is one TB approx. maintained several of SQL Server 2000 databases. Troubleshoot and resolved problems with Active Server Pages (ASP) accessing SQL Server data. Created and debugged DTS packages. Added and changed NT and SQL Server logons, users, and groups.

Installed oracle 8.x, binaries. Created and Upgraded SQL and oracle databases to current patch level. Reorganized databases, indexes and log files. Migrated VLDB using transport tablespace, Configured remote backups using RMAN.

Implemented strategies and design elements in cooperation with the other members of this re-architecture project team. Performed all facets of complete Oracle data engineering, from improving the day to day operation of existing databases to creating and executing the strategy going forward.

Kalé Consultants Ltd. Mumbai, India System Analyst Aug-95 to Sep-98

Project: Open Branch Management System. (OBMS) (38 Months)

Participated in all phases of development of this module. This includes gap analysis, impact analysis, writing code-using ProC, PLSQL. Installed oracle 7.x. Configured kernel parameter & init.ora parameters. Wrote dynamic backup script using PL/SQL & UNIX shell. Added jobs to cron tab. Monitored database using UTLBSTAT/UTLESTAT. Reorganized databases.

Amijay Elastics Pvt. Ltd. Puné, India Programmer Analyst Apr-93 to July-95

Project: Label Order Processing System. (28 Months)

Conducted system study & module development of the system. This is an integral part of the previous Project: encompassing operations such as quotation, order acceptance, purchase orders & bill generation. Actively involved in the design, development and implementation of the entire system. Used Erwin for data modeling.

Computers Unlimited. Nashik, India Programmer Jun-91 to Mar-93

Project: Asha. (Health Care) (22 Months)

Developed several modules to automate various functionality of the software, Wrote test cases to test software against possible failure. Developed fault tolerance system for this package. Prepared user instruction manuals.

Contact this candidate