Database Administrator Resume
4.00/5 (Submit Your Rating)
Columbus, OhiO
SUMMARY
- Database Administrator/Analyst with almost 20 years of wide-ranging technical experience.
- Keen ability to successfully support critical business requirements.
- Solid understanding of the relationship between technology and business targets.
- Exceptionally good at problem analysis, resolution, and troubleshooting.
- Excellent communication skills with the ability to interface positively with non-technical people at all levels.
TECHNICAL SKILLS
- Operating Systems: Windows Server 2012, Redhat Linux, Windows 10
- Applications: Windows Server Failover Clustering, SQL Disaster Recovery, Always - On, DPA
- Languages: T-SQL, XML, HTML, SSIS, Light SSAS, SSRS
- Script Languages: HTML, DHTML, MS PowerShell, WSH, Visual Studio, BIDS
- Tools: MS Access, MS Excel, SSDT, SQL Profiler, DTA, XEvent
PROFESSIONAL EXPERIENCE
Confidential, Columbus, Ohio
Database Administrator
Responsibilities:
- Implemented and Supported OLAP Database in a SQL Server 2016 Environment. Migrated Ported 6 month OLAP DB to Development Environment.
- SQL Server Database Administrator Tasks:
- DB Backup and Refresh of UAT QA, DEV and STAGE Environments in SQL 2012.
- Maintained and helped Create Processes to procure a 5 terabyte 30 day Disaster Recovery of Full, Differential, and Transaction Logs with PowerShell for 40+ client databases.
- Maintained Multiple SQL 2012 Reporting Servers for Tableau 10.
- Resolved Tableau reporting latency issues by initiating Stored Procedures process that created staged tables with MERGE Data Synchronization.
- Ran Daily 4 hour SQL Jobs to sync Tables for Tableau Reporting and LOB Dashboard Consumption.
- Implemented SQL Server 2012 Horizontal Partitioning Maintenance Strategy with subdivided PAGE Compression.
- Improved SQL READ performance by creating efficient Indexes and expanding Statistics sampling across tables larger than 120 million rows.
- Implemented Performance Analysis of Logs (PAL v2.7) to Baseline SQL Server 2012/2014/2016 Performance tracking.
- Created strategy to implement spanned DB backups for VLDB’s
- Implemented and Supported SQL Server 2012 Transactional Replication.
- Implemented SQL Server 2012 Extended Events to discover Long Running queries.
- Analysis of SQL Server 2016 Query Store to discover Query Plan Regressions.
- Created Multiple SSIS packages for LOB Reporting utilization with BIDS
Confidential, New York
Database Analyst
Responsibilities:
- Implemented Performance Management Data Warehouse in a SQL Server 2008 R2 Environment. Set up Instance Performance collectors and generated reports.
- SQL Server Database Analyst Duties:
- DB Migration of SQL from 2000 to SQL 2005 and SQL 2008 R2.
- Mid Level SQL Database Administrator in a large team supporting hundreds of SQL servers from SQL 2000 through SQL 2008 R2.
- Built several SQL Server 2008 R2 Failover Cluster Environments.
- Supported High Availability SQL Server Principal/Mirror in Prod and DR.
- Supported VLDB in a SQL Log Shipping Configuration.
- Architected SQL Server SAN Storage design for Database Builds and VM’s
- Examined Backup reports and remediated failed Backups daily.
- Setup and Supported SQL Server 2012 Always-On for PROD/DR Failover Clusters
- Implemented and supported SQL Server Merge and Transactional Replication.
- Implemented SQL Server 2005 Partition Function/Schema on 400 Million row tables and optimized maintenance. Horizontally aligned tables improving performance.
- Examined SQL Server Query plans and T-SQL Efficiency
- Used SQL Server Profiler to examine long-running queries
- Use Database Tuning Advisor to recommend Index table additions.
- Liaison with Application developers to promote Change Controls
- Supported full set of DEV, UAT and Performance Labs SQL servers.
- Developed SQL Server process documentation
- Functional Database Creation and Design in SQL Server 2008 R2
Confidential
MetaDirectory Administrator
Responsibilities:
- Group Policy Object (GPO) administration, troubleshooting, and management
- Monitoring and reporting associated with the reliability and security of the domain
- Used the domain admin account only for actions that require the privilege level of this account
- Monitored changes to domain root and domain controllers OU to ensure Un-authorized changes do not occur
- Day-to-day management of domain controllers.
- Monitored connectivity, synchronization, replication, netlogon, time services, FSMO roles, schema, NTDS database partitions, DNS settings, SRV records, and trust relationships,
- Reviewed DC event and security logs and take corrective actions.
- Monitored and resolved security situations at all levels of domain to ensure stable and secure.
- Domain Controller Management.
- Created and managed directory infrastructure
- Included FSMO roles, trusts, Kerberos KDCs, replication topology, etc.
- Full disaster recovery plan and practice of DCs and core Directory objects.
Confidential
Database Administrator
Responsibilities:
- Production database Operations support Lead for Engineering, Architecture, Design, Implementation & Production Support for Central Technology Services Globally consisting of over 400 database instances, 6,000 databases & 45 applications spanned throughout North America, Europe, Asia and Australia.
- SQL Server Technologies Implemented and Supported across all SQL platforms (also SQL Server 2008 & 2008R2) including Replication (transactional, snapshot, merge, transactional with updatable subscriptions, filtered, customized), Log Shipping, Mirroring (Synchronous & Asynchronous with and without Witness), Snapshots, Backups (full, diff, transactional, mirrored, remote)
- Design, Development, Document & Implementation of all in-house inventory and compliance tracking system based on the IT Security Control Policy and SOX compliance standards that are utilized on all database servers.
- Lead the technical scope documentation and drove the process for the internal Database Audit
- Engineering, Architecture, Build, Implementation & Support for all SQL Server related projects from SAN or NAS storage layout, Database layout, Partitioning, Disaster Recovery, Archiving Solution, ETL, Warehouse Design and Creation & Documentation
- Project scope including SharePoint 2010 & 2007, Exchange 2007 & 2010, Blackberry, Vulcan Helpdesk Ticketing & Live Chat system, Quest ARS, XEN, RMS, Gen-Y, ESX, VDI, Citrix, LEOSTREAM
- Database Liaison for team with Microsoft, Chase SQL Server Engineering & Database Technology group consisting of Database Technical Leads across all lines of business in the firm.
- Level 3 support specialist for SQL Server 24x7 for the most difficult database issues or highest impact SQL issue to the firm.
- Technical Skill set in Performance Tuning on the fly, Troubleshooting skill set, Replication, Failover, Forced Recovery, Database Repair (all types and versions)
- Production database support for multiple lines of business in the firm including Investment Bank, Retail, Treasury and Security Services & Private Bank. Project implementation and 24x7 database operations and on call support.
- Supported MS SQL 2008 Backend SharePoint Databases in a Log Shopped DR Configuration.
- Construction and Management of multiple custom replication environments for various Line of Business; replication DR requirements exceeding 500-batch transaction per second.
- Managed and performed troubleshooting on all SQL Server 6.5, 7.0 and 2000 production server’s platforms totaling over 1000 user databases.
- Participate in multiple Business Unit Contingency plans, Disaster Recovery plans and Information Security plans for multiple Lines of Business.