Sr. Database Analyst\sql Server Dba Resume
4.00/5 (Submit Your Rating)
OBJECTIVE:
Database Administrator/Database Analyst/ SQL Developer/Business Intelligence Data Analyst/ Reporting Engineer
SUMMARY:
- Reviews from Manager: “ Confidential has been a great asset in DB team and always been the one we can count on. She always goes extra mile to get things done, provides recommendation if applicable, provides valuable support to other team members, keeps her technical skill fresh and up - to-date, communicates well with team and other departments.
- A great attribute of Confidential is her ability to prioritize all issues, work closely with developers, AMs, and sometimes customers to solve difficulty problems.
- She is very effective at identifying problems and potential resolutions. She always approaches issues with “can-do” attitude and skillfully utilize all the resources available.
- Extensive experience in configuring, optimizing and administering MS SQL Server 2005/2008/2012 /2014 both in development and production environments.
- Robust experience in high performance data integration solutions- Microsoft SQL Server Integration Service (SSIS), including extraction, transformation, and load (ETL) packages.
- Solid understanding in Data Warehousing concepts, such Dimensional Modeling, Confidential and Snowflake Schemas
- Highly data driven and detail oriented. Willing to take responsibilities.
EXPERIENCES:
Sr. Database Analyst\SQL Server DBA
Confidential
Responsibilities:
- In Confidential environment, performed database administration tasks, such as new SQL server configuration setup, SQL Server migration, SQL Server downgrade, database backup, database restoration, disk space cleaning, maintenance plan creation, SQL Server Agent Job scheduling, monitoring of SQL Server, etc. Implemented custom Server Maintenance Solution to improve Index Rebuild time.
- Identify and solve performance issues in SQL server.
- Analyzing wait statistics available in DMVs to reduce the blocked sessions on production servers by adjusting Cost Threshold of Parallelism.
- Utilizing extended events in SQL Server 2014 to resolve deadlocks in the transaction.
- In depth experience in utilizing SQL Server profiler, Database Performance Analyzer (3rd party tool) and other 3rd party tools to capture poor performing Stored Procedures, functions and queries, and make fine performance tuning.
- Setup and manage transactional replication between Confidential servers.
- Troubleshoot and resolve user and database issues both in development and production environment.
- Develop table schema, Stored Procedures, functions, views, and triggers.
- Design, develop and maintain scaled solutions to support platform migration, data cleansing and data reconciliation using T-SQL, SSIS, and PowerShell scripting
- Play key role from DB team in platform migration and regular product upgrade release.
Sr. Data Analyst
Confidential
Responsibilities:
- Provide technical expertise in analyzing and processing clients’ marketing and sales data
- Projects range from CRM implementations and migrations to cleansing, standardizing, matching and consolidating SalesForce.com data
- Created ETL packages to automate data migration and data cleansing process using SQL Server Business Intelligence Development Studio (BIDS), deployed and scheduled packages.
- Created stored procedures, functions and views to provide customized data analysis inquiries from clients
- Independently migrated the data processing to SQL server 2008 from old system using SQL Server Common Language Runtime (CLR) and full text search.
- Developed projects using SQL Server 2008 SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships; modified cube and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions.
- Generated reports using SQL Server 2008 SSRS including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint.
Environment: SQL server 2005/2008/2012 , SSIS, SSRS, Access 2010, SalesForce.com, MS Visio, MS SharePoint, Visual Basic
Reporting Engineer
Confidential
Responsibilities:
- Generated variety of reports using SQL Server 2005 SSRS including matrix report, parameter report, and dashboard with charts and drill down function.
- Successfully implemented stored procedures to automate data analysis.
- Took initiatives to write sample code to do special data analysis for the team.
- Optimized existing store procedures and queries to enhance performance
- Added new features to the existing tools to facilitate project team.
- Assisted in the development of new tools
Environment: SQL server 2005, Access, SQL Server 2005 SSRS, asp.net, C#, Visual Basic, Access VB, ASP
Instructional Technology Specialist
Confidential
Responsibilities:
- Worked on web-based applications for outside clients. Responsible for software design, development, debug and documentation.
- Provided technology support to faculty, outside clients, and instructional design teams during the production of instructional materials.
- Coordinated the design and development of online, interactive, multimedia distance courses backed up by MySql database.
Environment: Perl, PHP, ASP.NET, C#, JavaScript, HTML, DHTML, XML, CSS, Mysql, MSSQL 2000