Dba Resume
5.00/5 (Submit Your Rating)
Boston, MassachusettS
SUMMARY:
- Years of database administration (DBA); trouble - shooting, tuning, and disaster recovery
- Extensive experience in developing SQL queries to support QA, sales and research
- Skilled in the communication of technical information in an accurate and precise manner
- Experienced in coordinating cooperative relationships with contractors, end users, and team members
WORK EXPERIENCE:
Confidential, Boston, Massachusetts
DBA
Responsibilities:
- Critical analysis, design, creation and maintenance of SQL databases in support of
- ETL processes
- Web applications
- SSRS and PowerBI
- PowerApps
- Advising and training team members in the creation of SQL queries, stored procedures,SSRS reports, and documentation.
- Daily support of personnel mining data
- Creation of naming conventions, optimization, and other best practices in an IT environment
- SSRS template creation for front end presentations
- Participation and planning of new Agile/Dev Ops/Scrum practices and documentation
- Assistance of scrum leaders and scum master with documentation creation and formatting in IT environments
- Participation in leadership teams’ creation of SOP’s, code cataloguing, and Microsoft’s DevOps environment tools
Confidential, Boston, Massachusetts
Data Integrity Analyst / SQL Developer / SQL DBA
Responsibilities:
- Critical analysis and maintenance of SQL database
- Design of backup and recovery features on local and remote storage
- Guided reforms of an existing database structure
- Upgrade of SQL and migration to new servers
- SQL 2008R2 to SQL 2104, and to SQL 2106
- Upgrade to Server 2013, to Server 2016, and Azure IaaS with PaaS webservice
- Proposed design of new structures as the scope of the department’s work increased
- Implementation of SQL Agents, wrapped in Maintenance Plans, to automate tasks and relieve resource stresses.
- Writing SQL ad hoc queries, stored procedures and reports
- Daily support of customer service personnel
- Tuning of existing queries / creation and maintenance of indexes, etc.
- SSRS template creation for front end presentations
- Create and carry out testing protocols for roll-out of new software and enhancements
- Assists lead developers with unit testing
- Performs and documents final testing
- Agile, Waterfall and blended software development life cycle procedures
- Acquisition of skills (as needed for a small shop that handles a lot of data)
- Tasks in IIS, SMTP email services, SSL installation, CRM 17 compliance, SSIS, etc.
- Security hardening of databases and servers
- Advanced firewall setup
- Network Security Group implementation
- Azure resource and architectures
- SQL encryption
Confidential, Columbus, Ohio
Database Programmer
Responsibilities:
- Ground-up programming of a laboratory information management system (LIMS)
- Governed flow of $50 million of product, per annum
- Integrated with the existing inventory database
- Automated comparison of product test data against specifications
- Automated the creation of Certificates of Analysis
- Created flexible, customized interfaces for Sales, Engineering, Lab and QA departments
- Switchboard entrances to the database
- Form and Report designs were planned and evolved based on the needs of different Departments and Groups within the organization
- Introduced systematic statistical analysis to manufacturing data
- Creation of a Continuous Improvement program in the manufacturing group
- Wrote test plans for database trouble-shooting
- Establishment of QC/QA documentation protocols to meet ISO requirements
Confidential, Plain City, Ohio
Project Lead
Responsibilities:
- Managed the packaging and presentation of data in support of chemical reactor development, maintenance, sales and customer support
- Statistical analysis
- Graphic presentation using Excel, Word, Movie-maker and Power Point
- Programming of software based control systems (National Instruments, Red Lion)
- Analysis of cosmetic, pharmaceutical, and chemical products and feeds
- Served on Committees for Improvement of Documentation, and Safety Committee
Confidential, Dublin, Ohio
Chemist
Responsibilities:
- Performed quality assurance analysis and manufacturing trouble-shooting of food and pharmaceutical products
- Maintained strict adherence to EPA and FDA regulations in a GMP/GLP certified and independently monitored laboratory