SUMMARY:

• Great Communication skills - ability to understand both the technical and business requirements and communicate them effectively.
• SOFT SKILS - strong work ethic, willing team player, sharing knowledge among team members.
• Database Architecture -spec out SQL instance based on requirements, Logical and physical database design, infrastructure planning, VM Consolidation
• SQL server Installation and connectivity
• SQL Database and server level configuration - Best Practices
• Database maintenance and logs
• SOX database Management ( Extensively Involved in DBMS that were under SOX guidelines)
• PBM - Policy Based Management - Enforce company database standards and SQL best practices
• Disaster recovery Planning and Design
• Database Mirroring
• Always ON Replica’s
• Log Shipping for Legacy SQL server systems
• Collect Vital SQL server data using stored procedures and DMV’S
• Advanced error handling for Stored procedure execution
• SQL server security/ Active Directory
• High Availability - Microsoft database Clustering - Installation, configuration, Maintenance
• HA + AG Design and Implementation
• Multi-Site WSFC + AG Design and configuration
• Traditional SQL Server Clustering - Active\passive, Active\Active\passive
• CDC- Change Data Capture, Page Level Compression
• SQL Server Management Data Warehouse - MDW
• SQL Server UCP - Utility Control Point
• SharePoint Database Admin
• SCOM - SQL Server management pack

TECHNICAL QUALIFICATION:

Software: SCOM, TSM, NETIQ, Tivoli, PBM, VERITAS Net backup

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, 2014 Standard/Enterprise/developers Edition

Op Systems: Windows 2000/Windows 2003/Windows 2008R2/Windows 2012 SQL Server Skills 2000/2005/2008/2008 R2, 2012, 2014

EXPERIENCE:

Confidential, New York, NY

Senior SQL Server Database Administrator

Responsibilities:

• Related activities for each client that was assigned to me. As the Lead DBA designed and implemented many
• Different database technologies. Working with many different clients has given me a broad array of experiences and
• Problem solving skills. Applying best practices and SQL architectural design was a regular part of my duties. Please
• Below some of the key skills that were required for my position at Confidential .
• Influence and provide leadership beyond your own projects and across multiple customers
• Provide technical escalation expertise for database system problems
• Provide design expertise for complex database solutions
• Maintain awareness of developments in emerging technologies and disciplines relating to present and future products and solutions through personal research, continuing education, seminars/trade shows and related activities.
• Increase and contribute to customer satisfaction and profitability.
• Promote and enforce adoption of standards, process, and SLA’s.
• Lead or manage work of others and other duties as assigned.

Confidential, New York, NY

Senior SQL Server Database Architect

Responsibilities:

• Implemented a MS SharePoint disaster recovery solution that allowed the firm to recover the environment in 2 hours. This was accomplished by configuring a WSFC cluster with SQL server across muilti-site data centers, leveraged the AlwaysOn SQL technology to replicate the content databases to our offsite location.
• Participated in the upgrade of the firm’s document management system (DMS). This project had two objectives: upgrade from Windows 2003 SQL2005 to Windows 2012 Data Center SQL2012 architecture. I designed and implanted a failover strategy that included HA plus AG; in order to have redundancy on the OS and database level.
• Completed an effort to enhance the Production support environment by configuring alerts and notifications for all SQL servers, by designing T-SQL scripts that created mail profiles and operators.
• Automated deployments using a SQL central management server topology; streamlining code deployment and maintain standards using policy based management. Other day- to-day activities included creating run books for system “Go-Live” events and fulfilling daily or weekly Change management request

Confidential, Englewood Cliffs, New Jersey

Senior SQL Server DBA\Architect

Responsibilities:

• As a senior level DBA I have the pleasure of being the lead DBA on some major projects for NBC. My responsibilities include providing 24X7 production escalation support, for any issues that our first level support team could not
• Resolve. I was part of the SQL Server infrastructure team which provided Support for many highly visible systems, such as GOLFNOW, GOLF CHANNEL, Wide Orbit Traffic (local Media), Universal Orlando Park systemsCharlotte News Channel (VOD). Working towards a common goal and meeting challenges is why I’m in the IT

Confidential, Charlotte, NC/New York, NY

Senior SQL Server DBA

Responsibilities:

• As the lead DBA for the equities trading system I lead the team in two major upgrades. The first upgrade consisted of migrating a standalone SQL2000 environment to a High availability SQL2005 multiple cluster architecture, which included an active passive cluster in Charlotte and Denver. I also designed and implemented the disaster recovery plan between the two sites. This particular application is one of the most visible and important applications for Confidential .
• The equities trading system second upgraded consisted of migrating the existing SQL2005 multiple active/passive cluster configuration to a multiple High availability SQL2008R2 environment featuring log shipping as the primary method for our disaster recovery plan. I also configured a warm standby server that could be activated very quickly if the business deemed it necessary. Eventually Log shipping was configured to use SAN to SAN replication to replace the copy function.
• One of my best skills and one I enjoyed very much was my ability to communicate with the systems development team. We were task with coming up with solutions that could not only improve the performance of the application, but make the environment more robust and secure as a whole.
• As the lead DBA for the equities trading system I was also called on whenever performance issues such as dead locking or any interruption to daily trading. The equities trading environment required a DBA who could handle issues very quickly under extreme amounts of pressure.
• As senior DBA I was also task with Creating procedures and processes that would be run on a daily basis to check the health of the Enterprise database environment. These process included streamlining backup procedures, health checks, SQL monitoring and Maintenance jobs.
• As senior database administrator I was also task with taking the lead DBA role for TIAA trust company which had a different report structure than Confidential . My role for trust including more tradition DBA responsibilities such as configuring Log shipping, backups, maintenance jobs. I also work closely with developers to resolve any common issues such as performance.
• As the Trust lead DBA my responsibilities also included heading up the trust upgrade project from SQL2000 to SQL2005.
• My responsibilities also including the evaluation and recommendation of third party products that could support management initiatives regarding the overall health and stability for our Enterprise SQL environments.
• In my tenure as a SQL DBA I have upgraded/migrated 100’s of database through many different OS and database platforms.

Confidential, New York, NY

Senior SQL Server DBA

Responsibilities:

• Net Asset Value which we call the NAV is a system that calculates the entire companies Net Asset Value on a daily basis, which will reflect every morning in the New York Times.
• Longview Trading system supports the company traders in three locations NY/CA/NC. The support for systems requires 24/7 coverage. The Longview trading system is a third party product present many challenges in the performance and tuning area.
• As senior database administrator I was assigned the task of creating a real-time disaster recovery plan for our investment accounting SQL server environment. I was also given the task of upgrading our SQL 6.5 environment to SQL 2000 during a period of great change at our company.
• Another group initiative was to develop an SQL SERVER ALERT system. This system would notify Database administrators, mangers or any other support personal via email or pager notification. This was accomplished by incorporating Microsoft Exchange server and SQL server. SQL server used Exchange server as a message distributor whenever certain SQL server errors were raised.
• As senior database administrator my responsibility also included supporting some of our most important Database applications such as our Portfolio Management system, National call center system, Individual/Institutional websites, Landmark trading system and Reconciliation. All of the systems mentioned were all daily measurements of the company’s day to day success.

Confidential, New York, New York

Senior SQL Server DBA

Responsibilities:

• As lead database administrator, my responsibilities included SQL Server installations and upgrades, device/file configurations, database design, system configuration, monitoring and preventive maintenance, backup strategy, system security, replication, server performance, monitoring and tuning.
• Upon joining IBI as a DBA, my first major project was ONYX, a web-enabled client/server solution for managing customer information across sales, marketing, service, and support teams. My responsibilities as a DBA included: implementing security features for data retrieval, designing leads processing business rules, converting data from old leads systems, design backend structure for web-based reporting, setup replication server for web reporting needs, configure Exchange Server to work with SQL Server to send messages, and any type of updates, additions, deletions, stored procedures, and triggers.
• Due to Confidential purchasing a new sales solution pack which came with inadequate reporting. The need to replicate the sales and marketing data to another SQL server used for reporting was imminent. It was my job to configure a one to many replication model.
• The second major project assigned to me was COSMOS, a centralized ordering, shipping, billing system utilizing three-tier architecture written entirely in Java. My responsibilities included: writing stored procedures to clean all tables with items marked as deleted, writing triggers, converting data using SQL Server 7.0 Data Transformation Service, design backup strategy, setup SQL Server 7.0 development environment for COSMOS team.
• While working on the projects mentioned above I was also responsible for maintaining all of the companies SQL servers, which included a mix of SQL server 6.5 and SQL server 7.0 servers. However most of the servers have been upgraded to SQL version 7.0.
• Took on a role as a senior Windows NT administrator. Responsibilities included installing and configuring NT test/development/production servers on the Information Systems Services domain. Configured TCP/IP, DNS, WINS, NTFS, and user workstations. Installed ARCserve on production server to backup entire ISS domain consisting of one PDC, three BDCs, three member servers, and 20 workstations.