sql dba ssis developer resume example with 5+ years of experience
JessicaClaire
, , 609 Johnson Ave., 49204, Tulsa, OK100 Montgomery St. 10th Floor
Home: (555) 432-1000
Cell:
resumesample@example.com
:
Summary
Skilled Database Administrator bringing more than Seven years' experience in the design and administration of databases, as well as key skills managing, Monitoring, Optimizing, troubleshooting to maintain the Integrity, Security, and Availability of databases. Hands on experience in Migration both on premise and Azure. Extensive experience in all SQL Server features such as Log shipping, Replication, Mirroring, Always On, SSIS and SSRS. Extensive experience with Power BI Administration, Power Apps, Dynamic MS365, power Query, Azure, Power Map, Power Pivot, Power View, DAX expressions, MDX calculations. Team-oriented with first-rate oral and written communication, complex problem-solving and decision-making abilities. Adept at managing concurrent objectives to promote efficiency and outcomes. I have a great Sense of ownership and pride in my performance and its impact on company’s success.
Skills
Provide 24x7 support for critical production systems
SSRS,SSIS, Tableau and POWER BI
SharePoint, power automation
Excel pivot and dashboards
Zoho and Salesforce CRM
Operating System: Windows Server 2008/2010/2015/2017/2019
Databases: MS SQL Server 2019/2016/2014/2012/2008R2/2008.,
Azure Online, Azure data factory, Azure data brick
Languages: T-SQL, HTML, XML, and Power Shell, MDX, DAX
Third-Party tools: Redgate Sql back up, Salesforce, service now, Jira, SharePoint
Features: Log shipping, Replication, Always On, Mirroring, clustering.
Experience
SQL DBA/SSIS Developer, 05/2021 to Current Lockheed Martin Corporation – Fort Belvoir, VA,
Created a data warehouse to offload responsibility from production database and for use of ETL process
Created and configured automated SQL Server agent jobs such as but not limited to Database backups, Integrity checks, Indexing Maintenance and Update statistics
Maintained the Integrity, Security, and Availability of MS SQL Server databases with TDE and always on encryption
Ensured that all databases are backed up in a way that meets the business's (RPO) and (RTO)
Established a plan for migration as well as applying service packs, hot fix and cumulative updates in development, test, and production environment
Creating SSIS packages for incoming data and automating
Configured, maintained, and established Tableau gateway connection to different sources to match analysis criteria and further modeling in different environments
Normalizing large amounts of Data for export to Salesforce CRM
Implemented Salesforce Data conversion and mapping
Created reports in salesforce
Designed and implemented wireframe, Prototypes standardization for Power BI dashboards & reports
Created analytical reporting utilizing analytical reporting with calculated Measures, columns using scripts and expressions
Database Administrator, 11/2018 to 04/2021 Accenture – Albany, NY,
Created and configured automated SQL Server agent jobs such as but not limited to Database backups, Integrity checks, Indexing Maintenance and Update statistics
Maintained the Integrity, Security, and Availability of MS SQL Server databases
Ensured that all databases are backed up in a way that meets the business's (RPO) and (RTO)
Established a plan for migration as well as applying service packs, hot fix and cumulative updates in development, test and production environment
Configured and Supported High Availability (HA) and Disaster Recovery (DR) strategies including Clustering and Always-On Availability Groups
Monitored, Tuned, Troubleshoot and Resolved issues including but not limited to SQL Server performance, database integrity, locks and deadlocks, connectivity, security native monitoring tools as well as third party tools
Established hardware requirements and devised storage capacity solutions for
Maintained DB integrity by limiting redundancy and using both system and user defined integrity
Worked with application developers to deliver data through the design of stored procedures, functions, and views
Performed security assessments to secure a database environment with TDE and always on encryption
Created roles and provided proper access based on need and approval
Took charge in Installation, Upgrade, Configuration and Migration of MS SQL Server in clustered and non-clustered production environments
Managed SSIS & SSRS packages
Involved in designing, configuring, monitoring, and troubleshooting replication methodologies
Performed SQL server Database refresh
Setup Transactional Replication to synchronize a subset of tables to multiple subscribers in real-time for reporting purpose
Clear understanding and practice of HIPPA regulations
Partnered with project management teams on development of scope and timelines
Assessed customer needs and goals through communication and system evaluations to modify existing databases for personalized customization
Established hardware requirements and devised storage capacity solutions for OLTP DB
Defined database design specifications based upon project requirements
Mentored newly hired employees, offering insight into job duties and company policies for easier transition to job position
Maintained proper documentation on all major changes, updates and fixes.
SQL Database Administrator, 02/2017 to 09/2018 Accenture – Tallahassee, FL,
Installed, Configured and Administered transactional replication
Configures Always on AG for out critical databases
Managed Server and Databases level TDE as well as always on encryption
Executed Migration projects in a timely manner with proper documentation
Performed Execution Plans Analysis for most resource-intensive SQL queries, stored procedures, and views, and optimized them for better performance
Maintaining high levels of performance, availability, sustainability, and security
Implementing and managing High Availability (HA) and Disaster Recovery (DR) options for SQL Server (Replication, Mirroring, Clustering, and AlwaysOn)
Performed 24x 7 scheduled and emergency technical support
Making sure standard backup policies are implemented across all servers
Implemented and tested the point in time recovery of the production databases
Responsible for monitoring and making recommendations for performance improvement
Exported and imported data files from source flat files, row files using DTS, SQL Server Integration Services.
SQL Database Administrator, 08/2015 to 12/2016 Johns Hopkins University – City, STATE,
Managed Database Migration of MS SQL Servers 2008R2 to SQL Server 2014 and Performed Product upgrades/installed services packs
Created, granted, and monitored user access rights and privileges through roles and profiles
Supported multiple databases for production, development, test and staging purposes on sun Solaris and Windows environments
Utilized monitoring tools and query execution plans to maintain and increase query efficiency and performed root cause analysis on query performance issues
Worked with application developers in the design, tuning, and indexing of tables
Helped improve performance of queries by analyzing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning
Wrote scripts and processes for data integration and bug fixes
Developed data models and database designs to plan projects.
Education and Training
Bachelor of Science: computer science, Expected in 05/2011 to Mount Ida College | Newton Center - , MA GPA:
Additional Information
AUTHORIZED TO WORK IN THE UNITED STATES (U.S. CITIZEN)
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.