| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address Nicholson Lane #135North Bethesda, MD Street Address
EMAIL AVAILABLEPHONE NUMBER AVAILABLEI have a strong understanding of database structures, theories, principles, and practices. I also have working technical experience with designing, building, installing, configuring, and supporting database servers, including SQL and other variations. I have hands-on database tuning and troubleshooting experience.Education:Bachelors degree: Computer Information Systems - Eastern Kentucky UniversityBachelors degree: Business Management - Eastern Kentucky UniversityProfessional Experience:SQL Server DBA & MYSQL DBA ConsultantMacarthur Beverages Inc Washington, DC January 2010 PresentAdministrative database development for SQL Server 2012 thru 2019 versionsUtilized T-SQL Stored Procedures, Complex SQL Queries, SSRS Reports Development, SSIS Package Development skillsSystem monitoring tool configuration and support.Geographic Information Systems (GIS) data conversions for shipping of orders.Data extraction and conversion for retail management system reporting.SQL Server DBA Consultant\ Data Scientist Healthcare January 2017 January 2024Gene Sweetnam, MD O.D., P.C. Burke, VAProviding 24/7 support for critical production databases.Providing Primary DBA responsibilities for around 10 applications.Migrated the SQL Server 2008 to SQL Server 2019.Migrated the SQL Server 2000/2005 to SQL Server 2008 and 2008 R2 versions.Installed of MS SQL 2019 on production, Test and Development boxes.Monitoring the data files, log file space issues, blockings, Tempdb space issues.Planning for backup and recovery of database information and maintaining Hot Backups, Cold Backups.Administering the MS SQL Server 2012, 2008, 2005 2000 by creating user logins with appropriate roles, dropping, and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.Using SSIS, building high performance data integration solutions, including extraction, transformation, and load ETL packages for data warehousing.Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.Migrating the database from existing 2000/2005 to 2008R2/2019 servers.Involved in General Database Administration, Query Performance tuning.SQL Server DBA Consultant\ Data Scientist Healthcare June 2015 November 2019Kenkead-Acree, MD FAPACreated EMR database and application for psychiatrist medical practice, by converting large EMR to new system, with only the functions needed by a FAPA medical practice.The new stand-alone application with local database, saved the practice money since they no longer must pay fees to EMR vendor.Provided on-going support as needed.SQL Server DBA ConsultantPECF/National Cathedral School Washington, DC February 2008 December 2020Application integration into real time reporting of metrics and alerts.Administrative database development for SQL Server 2012 thru 3019 versionsApplication support to Microsoft RMS Retail Management System.Application and administrative support for Blackbaud Raisers Edge fund raising software.Application and administrative support for EventPro event and security management software.Used strong T-SQL Stored Procedures, Complex SQL Queries, SSRS Reports Development, SSIS Package Development skills.Performed data extraction and analysis.Participated in change management process.Configured Firewalls, AD, and maintain user access.Provided troubleshooting and problem resolution skills for help desk issues.Worked collaboratively in a team environment with IT Staff and school Staff.Analyzed new technologies such as MongoDB and use of Cloud.SQL Server DBA ConsultantRockwood Specialties Chemical Company New Jersey November 2009 January 2017Setup and maintained sql log shipping for critical databases utilized by Hyperion/Oracle EPM Suite.Provided remote support for maintenance of databases and servers using SQL Server 2008/R2 and 2012/2014.Managed the setup of MS SQL Server databases at Business Continuity site.Assisted with server virtualization through VMware or Hyper-V.SQL Server DBA ConsultantLoudoun County Medical Group Leesburg, VA September 2010 June 2015Provided support for PULSE, eClinicalWorks, Allscripts, and other EMR systems.Installed, configured, and maintained Microsoft SQL Server 2008/R2 and 2012/2014 in Windows 2008 and Windows 2012 server environment.Tuned database configuration for optimal system performance.Ensured proper setting of system memory and system parameters in consultation with windows administrators.Managed MS SQL Server clustered environment for mission critical systemsCreated and maintained application databases with optimal data file and log file sizes.Aided developers in detecting performance problems including analysis of SQL, Transact-SQL, OLEDB and ODBC connections.Provided continuous monitoring, troubleshooting, historical and real time performance monitoring of the MS SQL Server environments.Provided backup and restore functions for MS SQL Server databasesAssisted with server virtualization through VMware or Hyper-V.Configure and manage the database systems as per security guidelines and industry best practices such as SOX, HIPAA, and PCISQL Server DBA ConsultantWorldSingles.com Silver Spring, MD September 2007 July 2011Application integration into real time reporting of metrics and alerts.Administrative database development usingConfiguration management tool development and supportSystem monitoring tool configuration and support.Geographic Information Systems (GIS) data conversionsData extraction and conversion for international dating siteConvert from SQL Server to MySQL.Used T-SQL Stored Procedures, Complex SQL Queries, SSRS Reports Development, SSIS Package Development skills.SQL Server DBA ConsultantNavy Federal Credit Union McLean, VA January 2006 March 2007Provide SQL SERVER database administration and server administration for MSSQL.Implemented infrastructure to support over 80 database servers consisting of more than 800 databases.Integrated business solutions and application software packages for client.Coded SQL queries and DTS packages to interface with DB2, Oracle, and Informix databases.Defined the business purposes and definitions of the data managed.Developed standards to measure the quality and adequateness of the data for the business objectives.SQL Server DBA ConsultantUS State Department Washington, DC September 2005 December 2005Provided SQL SERVER database administration, server administration, and supported the development team. Secret ClearanceImplemented the database infrastructure, database enhancements, and database performance tuning.Designed databases using Erwin.Documented system and database environments.Trained client staff.SQL Server DBA ConsultantUniversity of Maryland Eastern Shore, MD October 2004 February 2005Performed health check of PeopleSoft and SQL SERVER environments that control PeopleSoft Student Administration module.Implemented new database infrastructure techniques, database enhancements, and performance tuning enhancements.Documented the system and provided knowledge transfer to staff.Created SQL queries and reports for end users.Developed team project plan using MS Project and Visio.DB2 DBA ConsultantUSAA Insurance Company San Antonio, TX August 2004 September 2004Analyzed and made performance tuning recommendations to optimize the resource use, increase throughput and minimize contention, enabling the largest possible workload to be processed for the large-scale system to process auto policy claims.The operating system was IBM z/OS with DB2 V7.DB2 DBA ConsultantAlstom Power, Inc Upstate, NY May 2004 August 2004Provided remote and onsite DBA support of DB2 UDB V7.1 database on a NT server.Performed system level and application-level performance tuning of the Peoplesoft HR application, MTRAX Forms Time and Attendance application, and the DC Connect toolkit.Responsible for troubleshooting, capacity planning, backup/ recovery, and knowledge transfer to staff.DB2 DBA ConsultantNorthern Illinois University Chicago, IL October 2003 April 2004Acted as the DB2 Z/OS Technical Specialist to NIU.Provided remote and onsite support for the Peoplesoft ERP conversion from Informix database to DB2 V7. He installed and verified the DB2 database architectural environment.Trained the systems programmers and DBAs on how to install DB2 subsystems, Workload Manger, Process Scheduler, Performance Monitors, DB2 Connect, DB2 Control Center, and DB2 Tools and Utilities.Performed system level and application-level performance tuning.Provided project management support, and developed project plans using MS Project.DB2 DBA ConsultantNorthrop Grumman Washington, DC September 2002 August 2003Provided DBA and support to The Executive Office of the President of the United States. Secret ClearanceImplemented business practices that greatly improved the efficiency and effectiveness of Human Resources processes.Implemented duplex printing for all reports, to save paper resources.Implemented Crystal Reports Enterprise 9, so that bi-weekly reports could be available on the intranet and only printed at the users discretion.Responsible for all end user queries, special reports for the White House staff, and reporting for Congressional Inquiries.Utilized DB2, Platinum CA Toolset, MS ACCESS, COBOL, EZTRIEVE, MVS JCL, SQL, Crystal Reports.DB2 DBA ConsultantOSF Healthcare Systems Peoria, IL September 2001 September 2002Provided support for DB2/PeopleSoft implementation and performance tuning. The PeopleSoft Human Resources and PeopleSoft Financials were version 8; the RDMS DB2 V7.Performed analysis/verification of the DB2/PeopleSoft environment and installation.Responsible for troubleshooting, capacity planning, backup/ recovery, DB2 CONNECT, and knowledge transfer to staff.SQL SERVER DBACybersurf Inc. Reston,VADB2 Technical InstructorTecknowledge Columbia, MDSQL SERVER DBAPricesaroundtheworld.com Washington, DCSQL SERVER DBASRA United States Veteran's Affairs Washington, DCDB2 DBAKPMG Washington, DCOffice of the President of the United States (Clinton)DB2 DBAPEPCO Washington, DCUDB/DB2 DBAHBOC Rockville, MDDB2 DBAWinstar Communications Reston, VADB2 DBAHitachi Data Systems/Concept5 Arlington, VADB2 DBAGEICO Insurance Chevy Chase, MDDB2 DBAAmerican Management Systems, Inc. The Hauge, NeatherlandsDutch PTTDB2 DBATelenor of Norway Reston, VAOracle DBAUS Generating Company Bethesda, MDDB2 DBAAndersen Consulting Washington DCBell Atlantic & AmeritechDB2 DBAWashington Gas Washington, DCDB2 Sales SupportOn-Line Software International Denver, CODB2 AnalystMetropolitan Life Insurance. New York, NYIDMS ProgrammerUS Nuclear Regulatory Commission Bethesda, MDIDMS ProgrammerUnited States Mint Washington, DCQC Systems AnalystComputer Sciences Corporation Lanham, MDFederal Black Lung ProgramSystems EngineerEDS Bethesda, MDUS Immigration and NaturalizationSystems AnalystAppalachian Computer Services London, KYUS Immigration and Naturalization |
