TECHNICAL SKILLS:

Databases: MS SQL Server, Oracle, Sybase, Interbase, Paradox

Software: MSSQL 6.5, 7.0, 2000, 2005, 2008, 2008 R2, 2012, 2014 SQL Server Management Studio, SQL Server Business intelligence Development, SSIS, SSRS, SSAS, TSQL Studio, Enterprise Server, ISQL, Query Analyzer, Report Services, ETL, BCP, Oracle 7.3, 8, 9i, Oracle Enterprise Manager, .NET (ASP,C# and VB), PolyServe, Idera, Diagnostic Manager, Compliance Manager, Red Gate, Lite Speed, Sybase, Interbase, Delphi 3, 4 & 5, ColdFusion, Dreamweaver, Fireworks, Adobe Photoshop 7.0, DB Artisan, Toad, PVCS, Visual Source Safe, Visio, Erwin, Cobol II, C, C++, Visual Basic 6.0, Crystal Report writer, Xpediter, Assembler 370, CICS, DB2, Micro Focus Cobol, Micro Focus Workbench, OSVS MVS/JCL, TSO/ISPF, TPF, Panvalet

Concepts: Full Cycle Database Development to Production Administration, Optimization, Data Modeling, Normalization, Replication and Network Clustering, Data Warehousing, Program Design, Structured Programming, Problem Analysis, Advanced Troubleshooting, Table Handling, Documentation, Program Maintenance, Testing, File Manipulation

PROFESSIONAL EXPERIENCE:

Confidential, Mount Arlington, New Jersey

Senior Microsoft Database Administrator

Responsibilities:

• Contract position at ADP Total Source QSS management, Blue Sky MLS, Bed Bath and Beyond
• Assisted corporations and their technical DBA staff to resolve issues within their system utilizing my years of experience of the inner works of MSSQL.
• Advising of physical and system changes to be made to the existing structure to optimize performance in SQL queries application associated with MSSQL
• Mentoring those with less experience as to best practices and real world solutions. Giving them either work around scripts or a ways and means to resolve the issues on their own.
• Setting up systems or resolving issues with systems that were set up beyond best practices to work with storage and the end user or application
• Maintained and monitored Log Shipping on MSSQL 2012 servers.
• Created performance report and overall health to be used in management meetings.
• Created a project plan and coordinated the effort for compliance with security regulations to reset system passwords at a regular basis.
• Data mapping from flat files into existing and new tables using ETL SSIS
• Extracting data from multiple sources to create source for reports and view for analytical information

Confidential

Sr. Microsoft Database Administrator

Responsibilities:

• Maintained backups for all databases on over 40 SQL servers
• Databases Restoration and replacement of production to Dev or QA servers.
• Tuning indexes, creating new or removing old, outdate or unused indexes that have become obsolete.
• Checking for fragmentation and resolving those issues.
• Finding the cause of extended blocking deadlocking or bottlenecks.
• Maintained and monitored all instances of mirroring, troubleshooting any issues.
• Advising developers and management of best practices to improve work quality and avoid long running queries in the future.
• Resolving space issues and poorly written queries and application code

Confidential

Sr. Microsoft Database Administrator

Responsibilities:

• Maintained and administered the companies’ databases using SQL 2008, SQL 2008 R2 and SQL 2012.
• Maintained 16 mirrored databases synchronizing to a secondary site including a witness for automatic failovers.
• Maintained multiple snapshot and transaction replication to multiple servers constantly monitoring them for any issues.
• Created multiple alerts to notify me and the IT staff of any problems with Mirroring and replication as well as any issues with Dead locking.
• Created standards and held training sessions in query optimization.
• Trouble shot other issues with slow running processes and queries
• Created alternatives to link servers for local synchronized tables to enhance report times

Confidential

Microsoft Database Administrator

Responsibilities:

• Contract positions at Confidential Supply .
• Developed triggers and alerts for SAP using B1 up and other third party tools.
• Maintained MSSQL 2008 R2 databases.
• Created standards and held training sessions in query optimization.
• Trouble shot other issues with slow running processes and queries

Confidential, Teaneck, New Jersey

Sr. Microsoft Database Administrator

Responsibilities:

• Support and maintain over 750 MSSQL 2000 databases, over 50 MSSQL 2005 and 50 2008 R2 Databases hosted on over 80 servers.
• Established and maintained Log Shipping for warm standby on 2000, 2005 and 2008 instances for failover.
• Built and altered existing servers to configure for optimum performance and best practice processes. Moving databases and objects to take advantage of the SAN and new features in SQL 2005 and SQL 2008
• Installed 32 and 64 bit versions of MSSQL 2005 and 2008 and 2008 R2 on stand - alone and Clustered servers on Windows 2003 and 2008
• Created a suite of tables within a database to track and archive the system data associated with all SQL Servers in the organization. This was further used to analyze and forecast the future growth of disk drives associated with each server.
• Tested disaster recovery scenarios with the clusters and log shipping running on the clustered servers.
• Set up merge replication and database mirroring for other instances, monitoring them on a daily basis.
• Installed Rapid Mart and populated the database from production Oracle data using Data integrator to develop the data flows and objects used in the process to update the database from production Oracle. This is primarily to be used for reports for the business.
• Instructed the developers when needed optimizing the SQL statements used in the reports and application developed in-house.

Confidential, Mt Lakes, New Jersey

Microsoft Database Administrator

Responsibilities:

• Engineered and created an entire database to support an application to track and identify leased machines within an organization.
• This project was built with an ASP front end and .NET c# and powered by stored procedures within the database. It was also engineered using EWRIN to be 3 separate modules to be sold as whole or individual parts.
• Evaluate full system process across all functions, ensuring complete system integrity
• Analyze business needs to determine and write requirements if needed
• Allow for future growth of and capacity planning of the database and connecting systems Consolidation of 10 MSSQL servers into 1, with a cost saving of over $450K in licensing alone.
• Implemented an alternative to Microsoft’s clustering, with a cost savings of over $80K.
• Establish best practice guidelines for the development team Eliminated well over 40 databases in production to free up over a half terabyte of space.
• Set up notifications to automatically identify system errors and send detailed email direct to my mobile phone.
• Implement structural changes to the existing architecture
• Document all new and existing systems with standardized software documentation protocol
• Establish formal code review process and implementation
• Convert database versions from 2000 to 2005.
• Imported and created Data mart and Data Warehouse databases from existing databases.
• Designed and created reports thru reporting services.
• Responsible for all database changes and change documentation.
• Built web forms with .Net to administrate the information held in the database.
• Established a secure link with the customer to transfer sensitive data to and from the database.
• Implemented indexed views on a highly used database to increase throughput.
• Installed and maintained the PolyServe matrix server cluster solution for 3 instances.
• Re-wrote DTS packages to reduce the execution time from over 4 hours to less then 15 minutes. This opened up a window of system usability for the users.
• Helped implement a share point site for a central repository of information and documents.
• Troubleshot an existing instance of Oracle 9i that the backup software was not able to connect to the database.

Confidential, Landing, New Jersey

Microsoft Database Administrator

Responsibilities:

• Built and maintained multiple instances of MSSQL on a cluster 2003 server.
• Converted and consolidate multiple databases to the cluster server from DB2, Sybase, Oracle, and other versions of MSSQL.
• Built and maintain DTS packages using T-SQL to automate data processes.
• Implemented pull merge and dynamic merge replication.
• Physical and logical database design including indexes, triggers, stored procedures, and SQL tuning.
• Responsible for maintenance jobs and database backups.
• Setup multiple BCP jobs to process files coming from the mainframe.
• Wrote stored procedures to eliminate some batch processing that failed sporadically.
• Built a process to synchronize the sales force Sybase database to the new MSSQL 2000 while the migration is in process.
• Converted Stored Procedures and Functions from a Sybase version 6 to work in MSSQL 2000.
• Convert existing VB code to .Net.
• Contract for Thor Labs
• Build Ecommerce Web Pages using Cold Fusion for a new line of Laser devices to help increase baseline sales.
• Develop Charts and dynamic WebPages using Dreamweaver, Fireworks, and Adobe for graphic depiction of company’s products.
• Microsoft Database Administer using versions 6.5, 7 and 2000.
• General Contract
• Engineer and maintain database systems for small businesses.
• Build configure and install computers for individual homeowners and small businesses.
• Set up and maintain network systems for homeowners.

Confidential, New York, NY

Microsoft Database Administrator

Responsibilities:

• Administrate MSSQL (6.5, 7.0, and 2000) on NT and 2000 Servers.
• Daily maintenance of all 210 databases running on 20 servers.
• Continuous tuning databases for top performance.
• Migration and data conversion between all versions and files.
• Adjust the data and procedure cache to allow the proper balance.
• Nightly backup to hard drive and to tape to aid in recovery.
• Create additions to existing database and add new databases to the system.
• Write triggers, indexes, views and stored procedures for faster response to the user interface.
• Nightly trade feed monitoring into the production databases.
• Data manipulation using Transact-SQL and Enterprise Manager to correct user erroneous input.
• Built views for creating reports and adhoc reporting.
• Help create a data model to interact with a new product being created from specifications using Erwin and Visio.
• Install, maintain and version control of MS SQL systems.
• Responsible for the design, build, and architecture of the SQL servers.
• Plan and design disaster recovery plan then test into a simulated system periodically.
• Write the applications within 2 weeks that converted user’s trade data from one clearinghouse to another clearinghouse keeping a 3 Billion company from closing its doors.
• Develop software to support nightly trade input into the existing system.
• Develop new programs for replacement of aging systems, improving its functionality.
• Create tools to help administrate and schedule processes.

Confidential, Parsippany, NJ

Database Administrator and Developer Analyst

Responsibilities:

• Administrated Oracle (7, 8), Sybase, MSSQL (6.5, 7.0), and Interbase databases.
• Created Oracle instances, allocated space, defined/created databases devices, run/altered SQL scripts to created the tables in the database, tune Oracle instances for maximum performance, ran SQL scripts to update the database to higher version, database backups, database exports, database restores, database imports, remote administration through a dial up connection, download existing client databases from their servers for our test environment.
• Used Erwin and Visio to develop Databases and Database structures.
• Assisted client with any and all problems.
• Installed TruTrack, CS500com, Tasker, and any new task that may need to be placed on a customer servers or workstations.
• Remote install/instruction over the telephone with the customer doing the installation.
• Loaded, install windows 9x’s NT, or any software package that needs to be placed on any PC in the office.
• Administrated new and existing users in the network.

Confidential, Parsippany, NJ

Programmer Analyst

Responsibilities:

• Maintained and Developed programs for the Nation Screening center in Clipper
• Rewrote customer interface of the National Screening Center in Delphi
• Updated tested programs via modem/server connects
• Maintained and developed projects using Visio.
• Developed and design programs in Cobol and Natural batch and on-line
• Wrote JCL to run new and existing projects
• Maintained existing programs in the payroll and other systems for updates or changes
• Met with customers for updates and approvals of completed projects
• Documented and place into production completed projects