Database Administrator Analyst Resume Profile

Experience:

Confidential

Database Administrator Analyst/Programmer Senior Specialist

Associate in a database administration group for a major Stock Exchange. Systems are built on both Linux and Windows platforms using Sybase, SQL Server, MS Powershell, .Net, C , SMO, Perl, Shell Scripting, VB, ASP, PDW MS Parallel Data Warehouse .
Develop and support ETL Extract, Transform, and Load systems that process up to 20 million trading transactions on a daily basis.
Built robust automatic verification and reconciliation system to perform extensive data validation and ensure data integrity after loading and calculations.
SQL Server 2014 on Windows 2012 R2 64 bit .
Database design, maintenance, tuning, SQL performance, upgrades, replication Log Shipping, Snapshot, Transactional , backup, restores VERITAS,/OmniBack HP , disaster recovery planning and implementation, system documentation, hardware evaluation, vendor negotiations, support, auditing Sarbanes/Oxley and evaluations.
Planning, Installation, and Administration of MS SQL Server Clusters, in both Active/Passive and Active/Active configurations.
Planning, Installation of Sybase production and DR site for eSpeed trading systems. ASE, IQ, and Replication Server.
Review indexes, triggers, cursors, identity column, temp table usage, Partitioning and Compression.
Provide 24/7 on call support coverage.

Confidential

Senior Database Administrator

SQL Server 2005 on Windows 2003 64 bit Partitioned Tables, .Net, C , SMO, Mirroring, DB Snapshot for DR.
Database design, maintenance, tuning, SQL performance, upgrades, replication Transactional, Log Shipping and Snapshot , backup, restores Redgate , disaster recovery planning and implementation, system documentation, hardware evaluation, vendor negotiations, support.
Job Scripting, DTS package data feeds, SSIS, operations procedures, FTP, report design and implementation.
Review stored procedures, SQL code, Interactive routines for proper transaction coding and performance.
SAN Evaluation, benchmarking, design and implementation.
Evaluation: PolyServe Cluster Technology for SQL Server consolidation.
Evaluation of Database Monitoring tools, implementation of ProActiveDBA. Update and edit SQL best practices manual for Developers.
Review indexes, triggers, cursors, identity column, and temporary table usage.
Flash and Production Releases.
Provide 24/7 on call support coverage.

Confidential

Database Administrator Analyst/Programmer Senior Specialist

SQL Server 2005 on Windows 2003 64 bit Partitioned Tables, .Net, C .
SQL Server 2000 on Windows 2003 Erwin, Crystal Reports, Odbc, Vbscript, Jscript, Perl Script, DMO, SQL Profiler, Lumigent Log Reader and Entegra, System migrations.
Database design, maintenance, tuning, SQL performance, upgrades, replication Log Shipping and Snapshot , backup, restores VERITAS,/OmniBack HP , disaster recovery planning and implementation, database disaster recovery 9/11 WTC attacks and 8/15/2003 NYC Blackout , system documentation, hardware evaluation, vendor negotiations, support, and evaluations.
Job Scripting, DTS package data feeds, operations procedures, FTP, report design and implementation.
Implementing automated DTS packages for nightly processing activities, setting up email/pager alerts in DTS, converting manual processes for servers across the network to centralized DTS packages.
Review stored procedures, SQL code, Interactive routines for proper transaction coding and performance.
Planning, Installation, and Administration of MS SQL Server Clusters, in both Active/Passive and Active/Active configurations.
Administration of 44TB data warehouse, implementing federated database servers.
Review indexes, triggers, cursors, identity column, and temporary table usage.
Project leader for Server migrations, upgrades, and Database conversions.
Project leader for new reporting systems and nightly/monthly batch processing system.
Project leader for Sarbanes-Oxley auditing using Lumigent Log Reader and Entegra.
Provide 24/7 on call support coverage.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship