Senior Database Administrator Resume
2.00/5 (Submit Your Rating)
Irving, TexaS
SUMMARY
- Proven leadership skills at the Lead, Supervisor and Management levels.
- A mature, team - oriented, energetic individual with a focus on success and service.
- Strong verbal and written communication skills.
- Unquestionable personal and business integrity.
- Strong interpersonal, and relationship development skills.
- Versatile self-starter with a proven ability to learn quickly, adapt and deliver high-quality results on time.
- Strong document driven organizational skills, with the ability to develop and execute plans and accomplish goals successfully.
- Ability to create a collaborative work environment.
- Proven ability to bring complex projects to completion and on time and budget.
- Database Administration and development.
- Virtual server support with Virtual-box and some VMWare.
- Application Development skills
- CRM and Case Management support / services development.
- ETL integration across multiple server and Mainframe applications.
- Infrastructure Support / Projects - Open systems, network (LAN, WAN), storage, security.
TECHNICAL SKILLS
Operating Systems: Windows 3.1-Present, NT 3 - Win Server 2012; Linux Red Hat 6 - Fedora 16 & Ubuntu 11.04 & Mint 16 - 18
Programming Languages: tSQL, SSIS, PL/SQL, XML, Perl, Powershell, AutoIT, DOS batch, some Python and some C#.
PROFESSIONAL EXPERIENCE
Senior Database Administrator
Confidential, Irving Texas
Responsibilities:
- Remote and on premises MS SQL Server 2008; 2012; 2014; 2016; 2017 on HP server hardware, VM’s, Azure VM’s, and Azure SQLDBs.
- Remote and on premises MySQL 5.x systems
- Production, Staging and Development systems for all platforms
- Powershell
- Azure hosted Hadoop database on Linux nodes.
- SQLDownUnder
- SQLSharp
Senior Database Architect / Administrator
Confidential, Texas
Responsibilities:
- Lead a database team and design the architecture of data warehouse systems for credit report history.
- Support and maintain existing database fabric. Consult internal and external development teams and customers on big data solutions such as Hadoop HDFS, MongoDB, Cassandra, and Neo4j database solutions.
- Heavy work with Service Broker and XML. Write stored procedures, triggers, views, and functions in tSQL.
- Develop reports in SSRS which identify health of indexes, agent jobs, and disk utilization. Installs, maintains, supports, and documents Production, Development, Testing and Reporting database systems.
- Conduct Database Performance Tuning, Database Security, investigations, development and maintenance.
- Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications. Investigates, troubleshoots and corrects data and user related system errors, and ensures data integrity.
- Maintain windows clustered environments supporting SQL server version 2008, 2008 R2, 2012, 2014 and 2016.
- Lead development JAD sessions. Conduct training. Maintain a spirit of openness, information sharing inquisitiveness, problem-solving and support for common goals.
- Work with Powershell, DOS batch files, Perl, python and some C#. Use the Ola Halgren, Paul Randal, Glenn Berry scripts and Brent Ozar tools.
Sr Technical Service Engineer
Confidential, Richardson Texas
Responsibilities:
- Lead a team that provides on site software (both ARGO and SQL Server) installation and configuration assistance to projects.
- Perform backup and restores of SQL Server databases from testing to production implementations.
- Provide hardware and software recommendations to customers.
- Batch/Power shell scripting.
- Formal written and verbal technical presentations.
- Participate in architecture presentations and discussions with customers.
- Diagnose and resolve complex technical issues.
- Provide on-site and remote research assistance in support of problem resolution.
- Develop and manage technical and delivery documentation for both internal and external implementation projects.
- Develop training materials and procedures, and/or train users in the proper use of hardware and software.
BI Reporting Manager
Confidential, Fort Worth, Texas
Responsibilities:
- Manage a team of five Data Analysts and Report developers. Provide direction in reporting and business intelligence platforms across multiple applications.
- Collaborate with business stakeholders to identify and deliver improved reporting and data analysis capabilities.
- Assist in defining the company’s data strategy: centralized data collection and reporting; data analysis; selection and execution of data analytical and/or visualization tools and future direction with respect to end user needs. Define and enforce reporting metrics and standards.
- Provide best practice recommendations with Microsoft Business Intelligence tools including SSRS, SSIS, and SSAS.
- Collaborate with end users to identify needs and opportunities for improved data management and delivery.
- Oversee the ongoing development and operation of a business intelligence architecture that enables fact-based decision making and ad-hoc analysis.
- Oversee the ongoing development and operations of an operational data store and enterprise data warehouse.
- Develop new database reporting tools and add Dimensions and Fact structures to existing data warehouse.
- Develop ETL processes to support data warehouse using XML, MS Access, and text files as data sources.
Senior Programmer Analyst
Confidential, Arlington Texas
Responsibilities:
- Monitor databases with activity and performance monitors.
- Perform database backups, migrations, log shipping, and restores.
- Maintain dual node database cluster.
- Maintenance plan and SQL job management.
- DBA and Key Developer, Systems administrator and business analyst for Confidential
- Extensive SQL Programming of SQL Stored procedures, SSIS packages, Trigger, and Functions.
- SQL Server Performance tuning and Application / SQL Server DB Security.
- Procedure, Function and Trigger optimization.
- Design and implement ETL processes from Mainframe, Oracle, and GIS systems
- Create process to coordinate implementations of new code development and migration to production.
- Develop QA processes for project documentation using MS SharePoint.
Planning Systems Coordinator
Confidential, Arlington Texas
Responsibilities:
- Coordinate the analysis, selection, development and implementation of applications for the Planning Department.
- Development of the Amanda system for the Building Inspections Department. Manage training and development databases.
- Work closely with DBA’s to schedule production database administration.
- Maintain copies of the database and help manage database versions.
- Gather requirements from users and stakeholders and managing work order requests.
