| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLESKILLEXPERIENCEMS SQL Server DBA20+ yearsEDUCATIONNCU, Doctorate's Degree (1.3 years but not completed) Information TechnologyAIU, Master's Degree Information TechnologyNotre Dame, Masters/Executive Graduate Certification Business/NegotiationsVillanova, Masters/Executive Graduate Certification Project ManagementAIU, Bachelor's Degree Information TechnologyUTA, Senior status (4 years) Physics, Mathematics, Computer ScienceOTHER EDUCATION/CERTIFICATIONProject ManagementExecutive NegotiationsMCP-WindowsMCP-Database Administration SQL Server: 70-764 (Experienced through 2019)MCP- Formal training Certification by Microsoft Provider in 70-765MCSEMCTS SQL certified through UTAA+Kenexa Prove it Test: Scored above average on both the MSSQL DBA AND Developers.EXPERIENCEMotion Recruitment 8/2021-8/2023Senior SQL DBAFull Stack with focus on MSSQL Sr. DBA. Development included trouble shooting/recoding C#, Powershell (dbaTools), SSIS, SSRS, and WebFocusAdministered roughly 150 MSSQL Servers in extremely fast paced environments. SQL 2012 2022.Independently built, installed, and configured approximately 60 servers for migration from lower versions which included Always On, Clusters, Stand Alone servers running Developer, Standard, and Enterprise editions.Microsoft DMAAzure migrationReplication across multiple domains.Backups, Restores, Ola Hallengren, CommVault, EMC Dell.Responsible for maintenance, integrity checks, application SQL jobs involving extensive TSQL code, archiving, etc.Auditing: Automated audit logging from traces.Idera SQLDM, Idera SQLCMPerformance tuningService NowDocumentation for projects, configurations, and overall environmental systemsNPI 08/2020 6/2021Senior SQL DBAAnalysis, Design, Development, Unit Testing, Production Deployment and Support of database systems.Converted Access systems to Syspro and SQL Server. I converted and optimized over 30 Access queries to SQL Server stored procedures.Gathered business requirements from accounting and manufacturing to design, develop, test, and implement stored procedures for automated annual service maintenance invoices.Responsible for performance tuning activities.Responsible for maintenance, backups, integrity checks, etc.Note: Please view my previous positions to understand more of my talents.Inspirus 06/2019 7/2020Database Engineer IVInterpret and gather requirements from Business stakeholders and convert the requirement to various database strategies and implementation across all lower environments as well as Production.Analysis, Design, Development, Unit Testing, Production Deployment and Support of database systems.Provide advice and support to development teams, work closely with rest of the development teams.Responsible for performance tuning activities.MS SQL Server, PostgreSQL and MySQL: SSMS, SSIS, SSRS Administration and DevelopmentAWS, Aurora, RDS, EC2, S3, AWS Powershell,Subnets,Performance Optimization and troubleshooting: Indexes, wait types, deadlocks, extended events, system health, profiler, traces.Policy Base Management PoliciesETL, TSQL, Replication, Clustering.MS SQL installation and upgrades ranging from SQL 2014 SQL 2019.Maintained and monitored (SQL Jobs, Security, patches, backups, and restores, SQL Safe Refresh, Post-Scripts, and Developed Scrub scripts)Migration of on-premise data to AWS.PowerShell - automated scripts to migrate data to AWS. Shell, DOS, Java, BCP etc.Jira/Agile/Confluence, Track-it, Windows Administration, VMware, and various office related software.Independent TSQL Development included application stored procedures, automated scrub development, deletion of client data, report procedures, complex calculated algorithms for triggers, SQL Jobs, etc.Foglight, SQL Safe, and numerous other 3rd party software, Git Lab (Similar to Git Hub)Santander Consumer USA 10/2018 5/2019Database Engineer IVMS SQL Server and Oracle Administration/Development: SSMS, SSIS, SSRS, and some SSAS.Azure.Indexes, wait types, deadlocks, extended events, profiler, traces.ETL, TSQL, Replication, Clustering.MS SQL installation and upgrades ranging from SQL 2008 SQL 2016.Maintained and monitored (SQL Jobs, Security, patches, backups, and restores, Appsync Refresh, Post Scripts).FTP/SFTP (BCP/Flat file transfer).PowerShell, Shell, DOS, Visual Basic, BCP etc.Windows Administration, VMware, and various office related software.Splunk, DDBoost, Data Domain, Ola Halengren, VS Data and Schema Compare, Beyond Compare, etc.CITI 5/2015 3/2018Infrastructure MS SQL Management Technical LeadMS SQL Server/Development: SSMS, SSIS, SSRS, and some SSAS.SQL as a Service, MyCloud.Indexes, wait types, deadlocks, extended events, profiler, traces.ETL, TSQL, Mirroring, Replication, Log Shipping, Always On, Clustering.MS SQL installation and upgrades ranging from SQL 2008 SQL 2016.Expert with Disaster Recovery (able to automate with TSQL and integrate with applications).Maintained and monitored (Security, patches, backups, and restores, etc).Policy Base Management PoliciesSFTP (BCP/Flat file transfer).FTP (BCP/Flat file transfer).PowerShell, Shell, DOS, Visual Basic.Windows Administration, Linux, Unix, VMware, and various office related software.Ola Halengren, RedgateSQL Compare, VS Data and Schema Compare, Beyond Compare, etc.Visio.RIG DATA/OPS/DAEGIS 3/2012 4/2015MS SQL DBA (Contract)MS SQL Server and Oracle Administration/Development: SSMS, SSIS, SSRS, and some SSAS.AWS, Azure.Indexes, wait types, deadlocks, extended events, profiler, traces.Fox Pro to SQL 2008 R2 Migration.SSRS Automation.ETL, TSQL, Mirroring, Replication, Log Shipping, Always On, Clustering.MS SQL Installation and upgrades ranging from SQL 6.5 SQL 2014.Expert with Disaster Recovery (able to automate with TSQL and integrate with applications).Maintained and monitored (Security, patches, backups, and restores, etc).Indexes, wait types, deadlocks.SFTP (BCP/Flat file transfer).FTP (BCP/Flat file transfer).ASP.Net (web services - XML)..Net, PowerShell, Shell, DOS, Visual Basic, BCP etc.Windows Administration, VMware, and various office related software.Native SQL Backups, Lite Speed, Foglight, Redgate, Visual Studio, Visio.Verizon IT Management 9/1998 11/2012System Architect/DBA/Develop Technical LeadDeveloped, tested, implemented and supported Verizon's Central Office telephone equipment order transactions that traversed between CCP (Creation Capacity Procurement Telephone Equipment Ordering Application), Msolv(Logistics/Warehouse), SAP and external vendors using webMethods 6.57 on aUnix/AIX platform.Responsibilities included data transfer using Microsoft platforms so skills varied.Used all versions of MS SQL from SQL 6.5 through SQL 2008.Installed MS SQL 2005 and 2008 versions and initiated BI utilization of SSIS/BIDS.Administered, developed and supported billing servers and applications in Massapequa, NY.This included both advanced SQL programming and administration for large business billing data including accounts such as the federal government.Administration included regularly managing, testing and implementing SQL patch updates, user and group security enforcement, maintenance and backup jobs, email notifications upon errors, etc.Successfully upgraded MS SQL 6.5 servers (objects, data, scripts, etc) to MS SQL 2000.Began Verizon career as a lead in web development and SQL administration for the Verizon Pava PMO technical team.During this time, built the SQL server from scratch.Was a team lead for AAIS implementation team's technical support, administrator and software/hardware support.Technical advisor and lead web developer.Reported to managers and directors when evaluating and planning critical issues.Facilitated Conference Calls regarding issue management with Directors.Linked to Oracle 11g and fundamental SQL Plus.Analyzed and organized daily schedules involving routine activities, PC and Server deployment/inventory, work oriented travel itineraries and cost evaluation for staff.Nominated employee of the month for independently upgrading webMethods 6.5 to webMethods 7.Upgrade included TN, IS and Developer installations, all database and application configurations.Successfully completed many Unix, Windows and SQL Server builds and upgrades.Designed, wrote, tested and implemented various small and large applications.Technologies: Cold Fusion, Visual Basic, Java, Java Script, NetApps, Connect Direct, Sun Solaris, Legato, NDM, Linux, PC Anywhere, Lotus Notes, Exchange/Outlook, MS Power Point, MS Project 2000, Visio, Microsoft SuiteWarrantech 5/1998 9/1998OS and PC Hardware SupportWindows 95 OS Troubleshooting and Support.Windows NT OS Troubleshooting and Support.Mac OS Troubleshooting and Support.Hardware Troubleshooting and Support.Responsible for troubleshooting and repairing operating system and hardware for any PC or laptop that was under warranty with Warrantech.This work included both Windows and Mac OS environments.Pier 1 Imports 3/1997 4/1998Point of Sale Deployment and SupportSystems configuration and installation of all hardware and software involving 900 retail networks.Technical support to 2000+ end users.Assisted Unisys, Comdisco, Sac, IBM and GE technicians with troubleshooting and installing the 4690 Operating System.Successfully assisted in the deployment and support of the new Y2K Point of Sale System.Technologies: Telxon, Cisco Router, CSU/DSU WIC, Harmonics Retail Integrated Module, APC, Oneac, Panasonic Phone System, AT&T Phone Boards, 4694/4693 IBM Computer, 6885/6887 IBM PC, Ethernet Links, Lexmark Printer, HP Printer, IBM Monitors, Windows NT, Bunyar, MS Exchange, MS Outlook, Rumba 95, WinRop, MS Word, EATECHNICAL SUMMARYPlanning and Gathering System RequirementsSQL Server 6.5 SQL 2019SQL SSMSSQL SSIS/BIDS /DTS/Data ToolsSSAS and SSRSSSMS Links (Stored procedures/TSQL scripts/SQL Jobs/MS SQL and Oracle)WorkbenchMySQLPuTTyPostgreSQLAWS RDS, EC2, S3, Routing Tables, Public and Private Subnets, Internet and NAT GatewaysSQL Azure (MSSQL)Replication (Mirroring, Clustering, Publish/Subscribe)MS SQL Installation and upgrades ranging from SQL 6.5 SQL 2017Maintaining and monitoring (Security, patches, backups and restores)Linking to Oracle 11g and fundamental SQL PlusDatabase Architecture and DesignOleDB, ODBC, ADODBPowershellVisual StudioCan read and write in numerous programming languages but master of none except structured query languages. (C#, C, VB, Perl, Java, Powershell, etc)SFTP (BCP/Flat file transfer)FTP (BCP/Flat file transfer)ASP .NET and C# (web services XML)webMethods administration and development (XML/EDI/Java TN, IS and Administrator)Windows NT thru Windows 8 AdministrationVisual Source SafeUnix/AIXShell/Dos scriptIISVPNSharePointSQL6.5-2019, SQL, Web Methods, ASP, ASP.NET, A+, MCP: NT 4.0Enterprise, NT 4.0 Server, and NT 4.0 Workstation Certified. All Windows OS (NT-2008), Unix/AIX, DOS, VAX, Lotus, Access, Excel, Programming in Pascal, C, C++, C# Java, Oracle 8i, MS Power Point, MS Project 2000, etc.SUMMARYWorked in IT management for over 20 years. Masters in Information Technology and more than a year towards a Doctorate Degree in IT. A+, MCP, MCSE certified, and MCTS SQL trained. Most recent responsibilities included:MS SQL Server and Oracle Administration/Development: SSMS, SSIS, SSRS, and some SSAS.Provisioning SQL to the Cloud: Azure and AWSETL, TSQL, Mirroring, Replication, Log Shipping, Always On, ClusteringMS SQL Installation and upgrades ranging from SQL 6.5 SQL 2017Expert with Disaster Recovery (able to automate with TSQL and integrate with applications)Maintaining and monitoring (Security, patches, backups, and restores, etc)SFTP (BCP/Flat file transfer)FTP (BCP/Flat file transfer)ASP .NET (web services XML)webMethods administration and development (XML/EDI)Java, Cold Fusion, .NET, PowerShell, Shell, DOS, Visual Basic, BCP etcWindows Administration, Linux, Unix, VMware, and various office related softwareAppsync, DDBoost, Data Domain, Lite Speed, Ola Halengren, RedgateSQL Compare, VS Data and Schema Compare, Beyond Compare, etc.More in depth responsibilities included developing, testing, implementing, and supporting Santanders and Citis MS SQL Servers internationally and previously Verizon's Billing and Central Office telephone equipment orders that traversed from external businesses to various ERP systems including CCP (Creation Capacity Procurement Telephone Equipment Ordering Application), Msolv (Logistics/Warehouse), SAP, and external vendors using webMethods 6.57 on a Unix/AIX platform. Prior to this, administered, developed20nd supported billing servers and applications in Massapequa, NY. This included both advanced SQL programming and administration for large business billing data including accounts such as the federal government.HONORS, AWARDS and LICENSESMagna Cum Laude with both a BS and MS in Information TechnologyCash awards for good performance during crisis situations within VerizonAward and dinner at the Mansion in Dallas for independent work on webMethods upgrade (data and app)High School Scholastic Letter and National Honor SocietyLEADERSHIP ACTIVITIESSpecial Olympics Basketball Coach, previously a Supervisor for Six FlagsPreviously a Manager of Tan AmericaSome Technical Lead positions for VerizonHelped assist coaches and participate in the Teams in Training for the Leukemia & Lymphoma Society, North Texas Chapter (2006 present)Originator of River Legacy Park Fitness and Fun: http://www.meetup.com/RiverLegacyParkFitnessandAdventureHISTORY ACCOMPLISHMENTSWhile with Citi negotiated with 76 different groups from 26 different Latin American countries to help the US gain access to Latin American servers as well as successfully developing, building, and supporting both North and South American MS SQL Servers. The biggest Verizon accomplishment was developing an Issues Manager for the merging of former GTE and former Bell Atlantic to form Verizon. All of the above required extensive technical and communication skills in multiple languages. |
