Architect/dba (sql Server) Resume
SUMMARY:
- Expertise in DB Administration & Security, DB development, Performance Tuning and Optimization, Logical & Physical design, VLDBs, Windows & Unix systems and scripting,
- 7 years in Professional Services with customer - facing consulting, pre-sales and post-sales (expert in Confidential Infosphere Confidential ).
- Broad applications background with Trading Systems, Financial, Insurance, & Legal.
TECHNICAL SKILLS:
Databases: Sr. DBA - > MS-SQL Server 6.5 - 2014 DBA -> MySQL 5, Sybase ASE, Oracle 9i, Confidential DB2, MS-Access
Languages: T-SQL, Informix 4-GL, SQL, 'C', HTML, VBA, XML, sybPerl, shells
O/S: Windows NT/2000/XP/7/8, Solaris, AIX, Mac iOS, Linux
Hardware: Confidential RISC MPP, Sun Ultra E9000 SMP, HP Xeon SMP, NetApp, HP SAN
Self-Service Data Prep: Datawatch Monarch, Data Prep Studio
CASE Tool: ER/Studio, DB Artisan, Visio
Report Tools: Zendesk, Assyst, Jira, Bugzilla, Peregrine
Enterprise Tools: Dell LiteSpeed, Red Gate, VMware, TFS
Monitoring Tools: Idera DM, Dell Spotlight, SCOM
WORK EXPERIENCE:
Confidential
Architect/DBA (SQL Server)
Responsibilities:
- Designed, built, maintained and continuously improved SQL Server Cluster Production databases > 10 TB.
- Performed T-SQL Code Review and code releases using Agile methodology, performance tuning of T-SQL processes & SQL Server configuration and mentored Dev staff on T-SQL and trained junior DBA.
- Collaborated closely with development team to design, develop and deploy database extensions and modifications.
Confidential
SQL Server Architect/DBA
Responsibilities:
- Supervised 3rd party vendors (Blackbaud CRM & SAS) to integrate their applications with in-house databases, applications and business operations.
- Installed, configured patched, troubleshot, monitored, optimized, set up Security, backup/recovery schemes, Clustering, HA & DR solutions of SQL Servers.
- Mentored Dev team on T-SQL and Report writing using SSRS.
Confidential
Ops Tech Lead
Responsibilities:
- Directed the global roll - out of the Confidential infrastructure and database on-boarding process, built the architecture and set up Confidential monitoring in the Production/UAT/DEV environments.
- Maintained the incident management, problem management, patch management, change and request management.
- Tracked key performance and capacity metrics to ensure the on-going uptime of the infrastructure of the Confidential apps.
- Designed custom reports to use data from application repository along with Confidential data and facilitated the review of data to the audit team.
- Performed the testing and certification of the software component of Confidential (STAP) for Sybase, Oracle and MSSQL.
- Closely worked with Network provisioning team to install the taps/tap aggregators and connect them to the collectors.
- Engaged Confidential support by opening PMRs to identify and resolve issues discovered in Confidential software.
Confidential
Sr. DBA/Architect/Developer (SQL Server)
Responsibilities:
- Managed multiple instances of production SQL Server 2K - 2012, including installation, configuration, patching, replication, indexing, backup/recovery, capacity planning, HA & DR solutions (clustering, log shipping, db mirroring, Always-On).
- Provided 24/7 and subject matter expert support; diagnose and resolve technical problems relating to applications and database servers.
- Performed tuning and troubleshooting of database and application server processes, developed and optimized T-SQL stored procedures and triggers - gains achieved were 50x at times.
- Analyzed technical requirements, designed new data model and developed an application for 'Patent Tracking', for which I was the recipient of the prestigious annual Star Award in 2010.
- Upgraded SQL Server 2K servers to SQL Server 2005, and SQL Server 2005 to 2008; rewrote & migrated DTS packages to SSIS.
- Administered SSRS 2008, and designed and generated reports using BIDS.
- Developed scripts to automate database management processes; wrote and maintained technical documentation, defined & enforced database standards, practices and methodologies.
- Monitored database capacity including identifying potential data volume growth, assessing current virtual hardware and software performance and capacity loads, and proposing solutions in a proactive manner, avoiding decreasing db performance and outages.
- Built, deployed and maintained SSIS, SSRS, and SSAS artifacts.
- Troubleshot H/W and S/W including applications, O/S, network & databases, and managed implementation and integration of new applications.
Confidential
DBA/Developer (MySQL)
Responsibilities:
- Administered 6 instances of MySQL Server 5.0 databases that stored Nielsen & Arbitron Ratings Data allowing the operation of an electronic open marketplace for the purchase, trade, management, and distribution of radio and television advertising media time.
- Automated DB backups, setup MySQL replication topologies, optimized queries and server configurations, performed extension of Confidential tables, optimized MyISAM tables thru redesigning indexes and table row format alteration, reconfigured InnoDB tablespaces for Radio databases.
- Automated processes available to advertisers on the SWMX marketplace: order execution, delivery of creative, reporting, invoicing, and return on investment analysis.
Confidential
Professional Services Consultant Engineer
Responsibilities:
- Managed onsite implementation and system integration of database software security of this Linux - based network appliance that safeguards databases, facilitates Audit & Compliance, and addresses regulatory requirements (SOX).
- Provided outstanding customer service during engagements by troubleshooting complex technical situations, and resolving issues, problems and concerns to customers' satisfaction.
- Performed pre- and post- sales technical presentations, support and training as needed.
- Responded to technical components of Request for Proposal (RFP) and Request for Information (RFI).
- Identified, isolated and reported bugs in the software that were fixed by interfacing with QA and Development; proposed few improvements that were implemented.
- Acquired and maintained expert technical knowledge of Confidential products and presented technically accurate solutions to customers, and supported sales activities.
- Provided timely and professional customer interaction (verbal, written or Webex) and solicited customer feedback to improve service and respond to customer requests and ideas.
- Created and maintained technical documentation, best practices and methodology.
- Supplanted Technical Support team documentations with knowledge acquired from professional services engagements.
- Gained proficiency in MySQL, the RDBMS in this appliance-based technology, Services running on Linux and Technical Support.
Confidential
DBA/Developer (SQL Server)
Responsibilities:
- Administered, tuned, maintained, created, secured, replicated, backed up databases, automated scripts, developed Stored Procs& Triggers, improved database performance processes and SQL queries, and optimized database servers > 3TB.
- Provided production and operational support for 24x7 SQL Server7/2000, the ETL (DTS), the datawarehouse & the datamarts; performed capacity and business continuity for HA via clustering.
- Provided technical consulting to other members of the organization in all areas of database design and architecture, providing detailed analysis, feedback, hands - on guidance, mentoring and training.
- Provided support of mission critical systems and serve as primary point of contact for coordination and resolution of SQL Server issues.
- Conducted database sizing and partitioning analysis (RAID 1,5,10) and provided recommendations for performance and growth.
- Monitored legal and regulatory requirements for data auditing, security, and retention and implemented processes for compliance.
- Created and maintained schedules; managed concurrent projects to an on-time delivery and coordinated cross-discipline teams to resolve issues.
Confidential
Professional Services Consultant
Responsibilities:
- Reengineered mainframe insurance applications and converted VSAM files to run on a SUN Ultra E6000 (26 - nodes SMP under Solaris) with SYBASE 11 and on an Confidential SP (10-nodes MPP architecture under AIX) with Confidential DB2/Parallel Edition.
- Engaged appropriate technical resources during the pre-sales process, and took part in the work which involved data modeling, database administration, performance tuning and optimization of SQL queries, data conversion, prototyping and implementing for production.
- Worked closely with and provided technical directions for the sales team.
- Was major technical influence in the sale of Confidential SP hardware and DB2 Parallel Edition RDBMS to Prudential.
- Provided technical support in sales presentations and sales support, and prepared sales proposals for both Confidential hardware and software solution systems.
- Established a centralized knowledge database to all Program areas and thus helped to standardize data elements and reporting; designed and implemented a strategy to combine the many silo systems into one Enterprise Information System.
Confidential
Database Engineer (Sybase)
Responsibilities:
- Developed and supported trading systems for the Futures, Currencies, Options, and Equities of a Hedge Fund. Applications included Price Collection, Trading Signal and Order Generation, Slippage Reporting, and P&L reporting.
- Managed daily operation of batch systems for portfolios totaling $600m.
- Thoroughly familiar with all aspects of computerized trading systems including marking positions to market, applying proprietary statistical algorithms.
- Engineered all aspects of a database/code migration and application integration from Informix - SQL/4GL to Sybase.
- Built a Risk Management System that enabled analysis of trading positions, and a GUI front-end which allowed the trading desk to administer the system.
- Provided the technical experience and business acumen to effectively manage the proposal, execution, and delivery of complex projects.
- Performed Database and System administration for the distributed client/server processing environment: a network of 20 Sun SPARCstations running NFS/NIS and PCs and hot site Sybase servers.
- Extensive experience with the following software systems: SYBASE (Administration, Transact-SQL, APT-SQL, SQR Report Writer, DB/Library), SunOS, Sybperl, Korn and 'C' shells, awk, sed.