Senior Database Administrator
• Managed a team of 4 Conversion DBAs and 2 Data Analysts.• Responsible for writing T-SQL scripts/statements to analyze and translate customer data into Jonas' SQL database tables.• Interfaced directly with the customer to define mapping specifications based on data analysis.• Created, debugged, and executed T-SQL scripts and stored procedures that match data mapping specifications.• Performed ETL (extract, transform, load) data imports, exports, and modifications.• Performed quality assurance and database validation on all test and live conversions.• Created and maintained SSIS packages.• Experienced in implementing different types of Replication, such as Snapshot and Transactional.• Upgraded SQL Server 2008 R2 to 2014 on all servers - Production, Development and Test.• Extensively used SQL Profiler to troubleshoot problems and queries.• Maintained and updated backup schedule for production and test servers.• Worked with developers on database schema changes and database restore requests. • Experienced in monitoring performance and troubleshooting servers using Solar Winds and Idera SQL Diagnostic Manager.• Quickly and effectively integrate new information and skills to enhance personal performance or the performance of the organization. Learned from successes and failures. Regarded all experience as an opportunity to learn and improve.