I am an accomplished IT database professional with demonstrated success in designing and implementing solutions that improve business functionality. I possess a diversified technical background within the Enterprise. I have a proven ability to implement technologies that decrease costs, increase performance and positively impact the business.

Qualification Highlights

• 11+ years in the Information Technology Industry
• Microsoft Certified Technology Specialist - SQL Server 2005 & Windows 2003
• Highly adaptable and able to get the job done regardless of situation or technology
• Extensive experience working with all aspects of technology
• Deep understanding of technology with focus on delivering business solutions
• Ability to develop as well as administer all types of programming language and environments
• Polished leadership skills, with ability to motivate
• Broad experience in full project life cycle development

Technical Skills

Microsoft Windows 2000,XP, Vista, 7, Windows 2003/2008 Server

Microsoft Internet Information Server (IIS), Microsoft Exchange 2003, 2007, Windows Server Update Services (WSUS), CA Clarity (Niku) 7, Microsoft System Center (Configuration & Operation Manager) 2007, Symantec I3 Indepth

DATABASE

Microsoft SQL Server 7.0/ 2000/2005, 2008 Oracle 8i/9i/10g, MySQL, Microsoft Access

Visual Studio 2005 Team Suite, Toad, DBArtisan, RapidSQL, ER/Studio, Erwin, Rational Software Architect, RoboHelp, Captivate, Microsoft Office 2003/2007, Microsoft Project 2003/2007, Microsoft Visio 2003/2007, Crystal Reports 11, Adobe Photoshop CS2, Illustrator CS2, Acrobat 8, Eclipse, SnagIT 8.0,, Dreamweaver MX, Flash MX, VMWare, Microsoft Virtual PC/Server

JavaScript, T-SQL,PL/SQL, ASP 2.0, HTML, DHTML Visual Basic 6, VBScript (WSH), Powershell, XML, ColdFusion, C#, VB.NET, ASP.NETINFRASTRUCTURE

Active Directory, Group Policy, DNS, DHCP, WINS, DFS, Terminal Service, Synology, NetApp, LAN

Professional Experience

Confidential

New York, NY

Sr. SQL Server Consultant

• Implementation of a Windows 2008 R2 /SQL Server 2008 Cluster
• Identification and remediation of performance bottlenecks in Hedge fund Portfolio Manager application.
• Worked with application developer on database design strategies as well as overall query designs.
• Implementation of Database Mirroring in SQL Server 2008.
• Migration of existing SQL Server 2005 database to 2008
• Extensive development of T-SQL Stored Procedures, Views, functions and basic C# code
• Development of several automated report using SQL Server Reporting Services (SSRS). Previously these reports were done manually and required manual intervention during end of day processing.
• Extensive process automation using Powershell
• Cube development utilizing SQL Server Analysis services.
• Development of updated ETL processes utilizing SSIS to pull and process data from prime brokers.
• Develop a Disaster Recovery/High Availability plan
• Addition of subscribers to existing transactional replication schema.
• Design and implementation of peer to peer replication
• Implementation of Idera SQL Diagnostic manager and Quest Litespeed
• Investigation of Change Data Capture feature in SQL Server 2008 and Transparent Data Encryption
• SQL Server Storage design with NetApp

Confidential

New York, NY

Sr. Database Engineer Consultant

• Implementation of Peer to Peer replication
• Deployment of SSD (Solid State Drives) using FusionIO drive for one of the high profile applications at Confidential
• Performance Tuning of poorly running queries
• Development of T-SQL Stored Procedures, Views, functions and reports
• Windows 2003 & 2008 administration under a clustered environment.
• Management of 250+ SQL Server 2005 & 2008 in a mixed 32/64-bit environment
• Development of Powershell scripts

Confidential

New York, NY

Sr. SQL Server Developer/Administrator Consultant

• Design and Implemented SQL Server table partitioning. The implementation of partition enhanced the overall backup strategy and application performance
• Documented the SQL Server Infrastructure as well as defined a SQL Server action plan on the necessary improvements to enhance scalability, reliability and performance.
• Pinpointed and corrected issues with deadlocks that were causing issues with the overall application.
• Conducted intensive performance tuning on the database as well as the query level. Optimized slow running queries and recommend ways on how to improve the performance. Some optimizations were the Identification of tables with missing indexes, long running query and columns with missing statistics.
• Deployed Idera SQL diagnostic manager to proactively monitor SQL Server performance as well as alert when issues arise with the servers.
• Developed SQL Server maintenance reports with T-SQL. In addition, implemented maintenance jobs to reindex, update statistics, corruption detection and email performance report nightly.
• Implemented the use of Quest Litespeed to improved backup and recovery efficiencies.
• Developed in T-SQL Stored Procedures, Views, functions and reports.
• Implementation of Transactional replication for secondary reporting server

Confidential

New York, NY

Lead SQL Server Developer/Administrator Consultant

• Architected an AML (anti-money laundering) database for OFAC (Office of Foreign Assets Control) monitor to capture suspicious activity against sanctioned countries. Architecture included physical, logical and infrastructure design
• Designed an automated process to import 75 million SWIFT (Society for Worldwide Interbank Financial Telecommunication) messages with many different formats using C# and SSIS.
• Maintained and administrated databases in Development, QA, Staging and Production database server each with 400+ GB on SQL Server 2005 and Windows 2003 Enterprise Editions.
• Developed in T-SQL Stored Procedures, Views, functions, CLR and reports.
• Setup & maintain server virtualization.
• Implemented the use of Quest Litespeed to improved backup and recovery efficiencies.
• Improved recovery time objective and recovery point object of the existing database systems.
• Gathered Requirements from business users and documented changes in ongoing user documentation.
• Utilized Full Text Search and SSIS to develop a fuzzy searching algorithm.
• Setup of SQL Server 2008 in a development environment to test existing application with the possibility of the upgrade
• Maintained Microsoft Access database utilizing Visual Basic for business requirements development and SQL Server backend via linked tables.
• Implemented Transactional Replication for improved backup and recovery model.
• Maintained Project timeline in Microsoft Project and Sharepoint.
• Managed a global team of 5 with members in NYC and Bangalore, India.

Confidential

New York, NY

Senior Windows/Database Developer/Administrator

• Management of 150+ SQL Servers in a SAN (Clarion, DMX) environment responsible for $500 million of Thomson Financials revenue.
• Performance Analysis and Tuning and trending.
• Monitored and maintained SQL Server transaction replication.
• Documentation of server infrastructure
• Windows and SQL updates
• Installation of SQL Server 2005 in a cluster environment.
• Developed Stored Procedure, Views, functions and reports
• Monitored performance and issues through Symantec I3 Indepth
• Maintained Project timeline in Microsoft Project.
• Maintained the Windows 2003 server on which the SQL Server were housed. Maintained configured ODBC and other Windows configurations.

Confidential

Brooklyn, NY

Windows/Database Developer/Administrator

(Environment: SQL Server 2000/2005, Oracle 10g, Windows 2003, Active Directory, 18+ servers)

• Management of 18+ Windows 2003 server which include web and database services.
• Experience with supporting databases in environments using the following technologies: Microsoft IIS, ASP, ASP.Net, and ODBC.
• Experience in designing, implementing, testing and maintaining data replication services, as well as database backup, security and recovery strategies
• Design and implementation of data models and logical database designs for 8+ releases of eDocExchange and Portal.
• Experience supporting 100+ GB databases with of 15+ databases.
• Development of Windows Scripting Host (WSH), WMI, Powershell to automate routine administrative functions.
• Development of SSIS (DTS) packages
• Knowledge in SQL Server Replication technologies, database mirroring
• Installation of SQL Server 2005 in a cluster environment.
• Gathered requirements, developed test plans. Coordinated QA testing efforts and offshore bug fixes.
• Managed the migration of Oracle from version 9i to 10g as well as SQL Server 7.0 to 2000 and 2005.
• Assisted in the development of ASP.NET, Javascript, Coldfusion code.
• Setup, configuration, maintenance and troubleshooting of SQL Server 2000 and Oracle 9i databases. Design and implementation of data models and logical database designs for various administrative application as well as new web applications such as Release Tracking and Risk Management, Estimation & Sizing.
• Manage and coordinated network operation efforts, IT planning, security, and other technical areas.
• Architected the hardware, software and network requirements for Production, Failover, Development and QA environments
• Involved in a significant portion of the re-architecture of the Data warehouse/Data mart in order to provide a more scalable, robust, and reliable system. Furthermore, involved in the design, development and implementation of the ETL process was responsible for extracting data from various external systems like PeopleSoft, Remedy, Niku Clarity as well as home grown systems.
• Developed a reporting infrastructure built on Crystal Reports and housed within the Project Information Portal
• Maintain SQL Server 2000 & 2005 & Oracle 10g database on a Windows 2003 platform including all aspects of backup and recovery, performance tuning and administration.
• Design and implementation of data models and logical database designs for 8+ releases of eDocExchange and Portal.
• Development of PL/SQL and T-SQL scripts for integration with web application as well as administrative tasks.
• Supported the applications through Quality Assurance and User Acceptance Testing and fixing the defects.
• Development of database objects including database triggers, stored procedures, rules and defaults, partitions, functions
• Primary Administrator for 8+ systems such as eDocExchange, Portal, Clarity, iMark, Doors, Caliber, Risk Management, Release Tracking.
• Involved in configuration and tweaking of DNS, DHCP and Active Directory.
• Document all administrative functions using RoboHelp.
• Lead a team of 2 offshore developers/administrators.
• Manage and train Jr. SQL Server DBA/Developer & interns.
• Develop and implemented plans to oversee the data and database administration function of Microsoft SQL server 2000 and Oracle 9i.
• Ensured a smooth transition from a legacy application in Microsoft Access database to SQL Server 2000. This transition provided a more reliable and multi-user environment.
• Maintained Project timeline in Microsoft Project.

Confidential

Brooklyn, NY

• Upgraded and Installed SQL Server on Windows NT. Set Up and Managed Replication. Provided Production database support. Supported application developer group. Used DB Artisan to administer SQL Server systems.
• Developed a Confidential t information lookup on the web using ASP 2.0, SQL Server 2000.
• Participated in Disaster recovery testing. Wrote disaster and recovery planning and procedure documentation. Backed up and restored databases. Performed server disk space capacity planning and allocation.
• Developed database objects with T-SQL and PL/SQL.
• Setup, configured, troubleshoot and administered of Microsoft SQL Server 7.0 & 2000, Microsoft Internet Information Server (IIS) 4.0, 5.0. Responsible for setup, maintenance, deployment, troubleshooting, and administering the LAN as well as the Microsoft Windows NT network involving Windows NT & 2000.
• Creation of database objects including database triggers, stored procedures, rules and defaults
• Initiated performance monitoring and tuning including tuning of SQL queries. Securing user access, granting rights and permissions. Maintenance of database integrity, consistency and referential integrity. Diagnosing system problems.
• Participate in Logical and Physical Database Design.
• Basic Admin of UNIX (AIX 4.X) server. Basic Oracle 8i & 9i Administration

Confidential

New York, NY

• Instituted new network infrastructure that improved systems efficiency and dependability.
• Led effort to deploy Windows 2000 upgrade to more then 200 desktop using Symantec Ghost Enterprise.
• Setup, configured, troubleshoots, and managed deployment and administration of Microsoft SQL Server 2000, Windows 2000 Server and IIS 5.0 in a geographically dispersed environment involving more then 6 countries.
• Developed web application used worldwide for selecting correct student program based on various criteria and qualifications.
• Development and implementation of data models and logical database designs. Planned and conducted structured testing of database designs to confirm functionality and performance.
• Responsible for setup, maintenance, deployment, troubleshooting, and administering the LAN as well as the Microsoft Windows NT network.
• Created stored Procedures and views using T-SQL. Performed daily data integrity checks. Used maintenance schedule to automate database administration such as indexing. Used MS SQL server technologies such as replication, and DTS. Monitor and fine-tune MS SQL Server 7.0, 2000 and NT server configuration.
• Setup, configure develop; implement backup and recovery plans for network servers including Microsoft SQL server data using Veritas Backup Exec 7.x, 8.x. Configure, deploy, and troubleshoot LAN printers. Monitor the status of backup and LAN printers on a regular basis. Manage user accounts, access privileges, and network security issues, on Windows NT 4.0 servers, Microsoft SQL server, Microsoft Internet Information Server (IIS) 4.0. Used SSL to integrate data capture forms to SQL server database in a secure 128-bit environment.
• Analyzed company's needs, recommended appropriate network configurations to meet needs and client standards. Design, Implement, maintain and administer technical infrastructure needs for a secure environment. Test, install and configure the latest beta releases of Software. Performs customization and system administration for network management, task/project management on LAN. Analyzes, recommends, and evaluates new hardware, software and communications products for compatibility and applicability. Perform advanced diagnostics and maintenance on desktop devices when additional expertise is required.
• Program in Active Server Pages (ASP), SQL, HTML to integrated web site data capture forms with MS SQL server using ODBC. In addition to creating dynamically generated pages depending on user's preferences. Provided support and code modification for custom-developed MS SQL, Access, FoxPro database systems, including query tools such as Seagate Crystal reports. Program and assisted in designing of MS Access 2000 using MS Visual Basic scripting (VB). Programmed in Foxweb to integrated dynamically data from FoxPro database to the web.
• Trained seven interns on providing technical support of systems and equipment including maintenance of client software, NT administration, Email server administration, internetworking with TCP/IP.

Fluent in Portuguese, knowledge of Spanish, Basic French