Database Administrator, Senior, Infrastructure Resume
3.00/5 (Submit Your Rating)
Austin, TexaS
SUMMARY:
- Information Technology Management professional, skilled in developing project plans, status reports, scheduling and conducting meetings.
- Gifted in the ability to manage the day - to-day design and implementation of projects and exceed client expectations.
- Enterprise Database Administrator, with extensive experience designing, testing and supporting next-generation database solutions in SQL Server environments.
- Proficient in an assortment of technologies, including Network Admin Specialist, Helpdesk software design and support to include Service Desk, Remedy Asset Management, MS SQL Server (SSAS, SSRS, and SSIS), HA/DR Solutions to include AlwaysOn, and Log Shipping, MS Access, Windows Server 2000, 2003, 2008r2, 2012, 2014, Data Center (complete list on request).
- Excellent communication and. teaming skills and maintains a “Can Do” attitude
WORK EXPERIENCE:
Confidential, Austin, Texas
Database Administrator, Senior, Infrastructure
Responsibilities:
- Reporting directly to the Director of Infrastructures, ensuring all database data is protected by a backup and meets the business’s RTO/RPO requirements and data can be completely restored
- Implement and configure SQL Server monitoring to minimize false alarms and maximize preventative actions
- Responsible for troubleshooting and resolving database integrity and performance issues
- Communicating regularly with infrastructure and Operational teams ensuring database integrity and security.
- Setting up, testing and managing DR capabilities to includes AlwaysOn Availability Groups, Log Shipping, and Mirroring
- Troubleshooting and resolving database integrity and performance issues
- Administer SQL Windows Failover Clustering systems and environments
- Develop and maintain installation, configuration and maintenance procedures for development, user-acceptance and production environments.
Confidential, Cedar Park, Texas
Database Administrator, Senior, Application Support
Responsibilities:
- Investigate, analyze, correct, and document reported defects or database performance issues.
- Monitor SQL Server performance with SQL Sentry (Performance Monitor /Advisor, Fragmentation Manager and Plan Explorer) and Spotlight on SQL Server Enterprise.
- Capture the appropriate steps to alleviate the problem, perhaps by tuning a query, adding an index, improving the disk subsystem, or simply terminating a blocking session.
- Teamed with Network operations to design and implementation AlwaysOn High Availability test solution
- Troubleshoot, deadlock, blocks and long running queries.
- Resolve issues proactively, before they impact the business
- Within first 90 days of hire maximized SQL Server database performance.
- Utilized Dynamic Management Objects (DMO) to included Dynamic Management Views (DMV) and provided our Custom Application team with a quick glance and resolution of performance issues.
Confidential, Fort Hood, TX
Data Project IT Manger / Senior Database Administrator
Responsibilities:
- Serve as the BI Project Manager for 14 or more projects and deliver project execution plans with minimal oversight. Drive projects from inception to existence successfully;
- Manage the day-to-day design and implementation of projects and exceed client expectations. Manage Helpdesk software development and support to include Service Desk and Remedy. Mediate incidents request and change management to document resolutions and root cause. Provide 24/7 support for critical production systems. Assist Information Security Officer (ISO) implementing policies and procedures to safeguard against malicious attack, due to unauthorized network and data access.
- Develop Automated Information Systems (AIS) security contingency plans and disaster recovery and failover procedures .
- As Data Project Manager, develop project work plans, develop status reports, schedule and conduct status meetings
- Supervised Database Admins, Programmers and Web Developers. Communicate regularly with technical, applications and operational staff to ensure database integrity and security.
- Gifted ability to work with stakeholders to identify best practice processes and institutionalize the adoption of processes across a diverse organization; and understand \ Implement the SDLC & AGILE process and able to work with developers to create and instill best practices across the organization.
- Serve as SQL Server DBA, responsible for developing, managing and testing back-up and recovery plans to ensure that storage, archiving, back-up and recovery procedures are functioning correctly.
- Responsible for mentoring and training on database technology and best practices.
- Monitor database performance and manage to provide fast query responses to front-end users.
- Map out the conceptual design for a planned database in outline. Refine the logical design so that it can be translated into a specific data model. Install and test new versions of the Database Management System (DBMS). Maintain data standards, adhering to the Data Protection Act and HIPAA compliant environment including SSN data de-identification
- Responsible for compiling database documentation, including data standards, procedures and definitions for the data dictionary (metadata). Control database access permissions and privileges.
- Serve as the primary coordinator between IT, SAN Administrator’s and others on the planning and tasks involved in the success of projects and maintenance windows
Confidential, Fort Hood, TX
Senior Data Analyst
Responsibilities:
- Established data quality & testing assurance for various data products built for deploying Units.
- Provided role names for upper Tactical Internet Confidential Battle Command Systems (FBCB), (JCR) etc.
- Briefed unit representatives on use of Confidential naming convention for Data Products
- Responsible to import authoritative source data to determine proper and accurate naming conventions for various Confidential units at all echelon levels.
- Additionally, responsible for executing and analyzing datasets from several different types of data synchronizations to determine differences between paired data products, user testing.
- Analyzed data with standard statistical methods, interpreting the results, and providing written summary of data analysis.
- Mentor, coach and train developers and analysts on best practices regarding database technology; and take a thorough, detail oriented approach to solving all business and technical problems.
- Shared the knowledge of analysis techniques and data coding with other staff. Working with Systems Architecture to design and develop statistical analysis, which address projected research questions.
Confidential, Alexandria, VA
Senior Enterprise Database Administrator
Responsibilities:
- Served as Enterprise Database Administer for the entire Confidential Test & Evaluation Command remotely base at Operational Test Command (OTC) West Ft Hood Texas. Teamed with the Senior Network Administrator and System Administrators to migrate 20 Physical database servers to VMware (P2V). Managed all Virtualized Database Servers.
- Supervised and provided training for the Assistant Database Administrator, Programmers and Technical writer.
- Performed duties as alternate AMS supervisor ensuring that all supervisory tasks are implemented in a professional manner in the absence of the AMS supervisor, to include preparing performance appraisal and evaluations, hiring selections and mentoring/disciplinary recommendations
- Responsible for the remote management (via Remote Desktop Manager, VM client and Dame-Ware tools) of the Confidential Test and Evaluation Command ( Confidential ) Decision Support System (ADSS), located at Confidential Headquarters in Alexandra, VA and all Confidential Management System (AMS) databases.
- Served as DBA project lead in SQL Server upgrades, upgraded SQL 6.5 databases to SQL 7.0 to SQL 2000 to 2005. Staying current with technology upgraded all SQL 2005 databases to SQL2008.
- Developed and tested storage strategies and disaster-recovery plan for large manufacturing company’s operational database, delivering solution that guaranteed recovery performance and high availability.
- Troubleshoot client/server problems/procedures. Follow the established procedures to ensure achievement of data quality, safety, and security standards.
- Created and generated tables, stored procedures and views with the use of the Transact SQL language ranging from basic to complex queries. Mirror SQL databases between Windows servers.
- Assisted programmers in testing stored procedures/program debugging on production and development systems.
- Ensured proper licenses where maintained on all servers/database.
- Implementation & Administration for all Computer Associates Helpdesk Support Applications. Perform web modifications in the absence of the Service Desk Web programmer. Performed monthly server maintenance, which included 35 production and development databases.
- Tasked and completed a successful upgrade to include creating a load balance of a 3 server farm (Application, Index and Database) environment. A keen ability to troubleshoot very complex technical issues and provide reasonable solutions in a timely fashion; A keen ability to troubleshoot very complex technical issues and provide reasonable solutions in a timely fashion; Experience includes designing, tuning and administering Microsoft SQL Server database systems to include performance monitoring and optimization technologies.,
Confidential
Technical Writer/Trainer
Responsibilities:
- Responsible for developing software release notes, writing software manuals, and installation instructions for all Confidential Management Systems. Test software functions and corresponding documentation.
- Incorporated changes from software releases into existing online help using RoboHelp and other documentation tools as specified. Reviewed published material and recommended revisions to content and format as needed.
- Also teamed with SMEs to assemble material for internal and external government customer training used during the testing of weapons, equipment and doctrine.
- Served as Application Trainer for the Operational Test Command ( Confidential ) internal training process as well as customer training and implementation projects.
- Conducted classroom training, presentation style and techniques for assist military, civilian and contractor staff.
