Resume

Sign in

Sql Server Project Manager

Location:
Mansfield, Massachusetts, United States
Posted:
January 09, 2017

Contact this candidate

* ********* ****

Mansfield, MA *****

Phone 508-***-****

E-mail: acx6sg@r.postjobfree.com

MARINA NOSOVITSKI

Summary

Talented and highly motivated Technical Specialist with excellent analytical, leadership and interpersonal skills, an aptitude for problem solving. Demonstrated solid system administration, SQL server administration and application management skills, problem-solving and creative abilities. Understanding ITIL concepts and practices. Proficient in testing and implementation of business applications. Expert in in delivering to deadlines with the ability to prioritize projects while committed to meeting and delivering on company objectives, logical and physical database design, architecture, performance optimization, coding and testing using SQL Server 2005/2008/2008R2/2012/2014/SQL2016, SQL LiteSpeed/TSM, ETL, Service Now, Business Objects. Well experienced in living in diverse cultures and working for a multinational corporation.

Technical skills

Proficient in System Administration, SQL Server Administration and Management Applications.

Excellent Leadership Experience

Familiar with ITIL concepts and practices.

Experienced with Remote Services

Proficient in delivering to deadlines with the ability to prioritize projects while committed to meeting and delivering on company objectives.

Proficient in logical and physical database design and architecture.

Experienced lead complex, time-critical IT work and facilitate activities between the business and IT during inception through delivery

Expertise with MS SQL Server 2008/2008 R2/2012/2014/2016 (including all related MS SQL Server tools.)

Proficient in Replication – Snapshot, Merge and Transactional.

Experienced in SQL Server Log Shipping and Mirroring

Proficient in Multi Clustering Microsoft Configuration

Proficient in database configuration, performance optimization, backup and restore, security, and maintenance.

Proficient in data analysis and data conversion across various databases.

Expertise with SQL syntax including, stored procedures, functions, views, triggers, queries and DTS/SSIS packages.

Experience in Replication – Snapshot, Merge and Transactional.

Management of multi-terabyte Clustered systems using Active-Passive and Active-Active Clustering.

Experience with implementing Database Disaster Recovery and Planning

Proficient with ETL tools and processes, primarily with SSIS 2005/2008/2012/2014, DTS.

Experience supporting and deployment of complex SSIS packages.

Skilled in database monitoring and tuning techniques including query optimization, indexing and SQL server configuration.

Experience in testing of all products from developers for release.

Experience with Business Objects, SQL LiteSpeed backup.

Experience with Management Control process.

Experience in writing test plans and test cases.

Proficient in supporting maintenance and enhancements of existing interfaces.

Solid understanding of software development and release process, working with source control system (Microsoft Visual SourceSafe).

Strong SDLC knowledge and project management experience

Experience with John Galt and Crystal.

Experience with Active Directory and Resource Directory systems

Experience in Client/Server applications using with C/C++, MS Access, HTML,ASP, SQL, VB Scripts, and JAVA Scripts.

Experienced with Microsoft SharePoint Portal Server, Microsoft Team Service, document management and collaboration tools.

Working knowledge of Microsoft Webpart and .NET framework.

Experienced in UNIX Shell Scripting, UNIX System Programming.

Solid knowledge of Windows 2000/2003/2008/2008 R2/2012.

Employment

6/2016 – Present Home Site Ins. Boston, MA

Sr. Project Manager/Technical Analyst

oResponsible for supporting all aspects of hosted MS SQL databases in production environment(s) located in corporate data centers to include but not limited to server, software, and MS SQL

oInstalling and configuring databases and layered software products with instructions from vendor, as needed.

oManage day to day system needs and ensure that the system and its interfaces are functioning properly and efficiently.

oPerforming system administration, SQL Server administration and application management tasks

oResponsible to oversee, maintain, and improve databases monitoring.

oManage the resolution of complex database related issues and outages.

oEnsure that processes and documentation are adequate and effective to meet specifications and audit requirements.

oWork with vendors and application support teams to gather information, determine and implement resolution

oResponsible for all aspects of the project delivery, including managing the scope of the project and changes to the project deliverables

oEnsure that approved IT requests are ushered through the life-cycle process on time and to scope

oAct as an evangelist and mentor for the software development life-cycle and actively promotes ongoing improvements

oMonitor tasks on an ongoing basis, evaluating progress and quality, managing project plans, issue and risk tracking and resolution, and taking corrective action as necessary

oMaintain liaison with stakeholders on technical, management, and budgetary matters

oConduct kick-off to communicate individual roles and project deliverables, meets regularly with team members to ensure project execution is on-track through delivery

oMotivate and inspires other team members and ensure they have the tools and training required to perform effectively

oAnticipate stakeholder needs and proactively develops solutions to meet them.

3/2014 – 6/2016 Capgemini Marlborough, MA

Sr. DBA/Sr. Consultant Delivery Team Leader

oResponsible for supporting all aspects of hosted MS SQL databases in production environment(s) located in corporate data centers to include but not limited to server, software, and MS SQL

oResponsible for database performance, configuration, backup and restore procedures.

oManage tickets across the MS SQL technical queue

oManages data warehouse configuration and performance tuning.

oResponsible for Mirroring, Log Shipping and Clustering configurations

oManage the resolution of complex database related issues and outages.

oResponsible for DR for SQL Servers

oCollaborate with application in Infrastructure teams to solve database level issues including availability and stability of database environments

oTroubleshoot and analyze problems and identify alternative solutions

oSetup and constantly improve maintenance, operational and monitoring processes

oResponsible to oversee, maintain, and improve databases monitoring.

oMonitor and optimize physical storage for database systems

oManaging offshore resources in a 24x7 environment

oProvide team with development opportunities for professional growth.

3/2013 – 3/2014 Autopart International. Norton, MA

Sr. Database Administrator

oProvide optimization and performance tuning of JD Edwards Enterprise One and POS applications in a SQL Server 2008 / Windows Server 2008 environment

oResponsible for database performance. Configuration, backup and restore procedures.

oResponsible to oversee, maintain, and improve databases monitoring.

oManages data warehouse configuration and performance tuning.

oCollaborate with application in Infrastructure teams to solve database level issues including availability and stability of database environments

oManage tickets across the MS SQL technical queue

oProvide optimization and performance tuning of POS system in a SQL Server 2008 / Windows Server 2008 environment

oResponsible for Mirroring, Log Shipping and Clustering configurations

oResponsible for DR for SQL Servers

oProvide performance tuning of other purchased and in-house developed SQL Server applications

oCreating Stored procedures, views and functions

oImplement SQL server enhancements and updates to ensure technology is current.

oProvide development and production support for complex SSIS packages

oImplement enhancements to the company major reports and SQL updates process

oCoordinate Maintenance for all SQL Server database applications.

oMonitor and optimize physical storage for database systems

oDevelop and evolve the logical and physical database design for our application

oProvide optimization and performance tuning for all database designs

oDesign, develop, and implement data warehouse solutions using SQL server or other applications

oWork with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures

8/2005 – 2/2013 Hasbro, Inc. East Providence, RI

Sr. DBA/Sr. Technical Analyst

Working as a production Support/SR. Database Administrator/Technical Consultant in the IT's Service Delivery department. Responsible for production systems, ensure that production systems run 7 x 24 except for planned maintenance.

oResponsible for all aspects of the project delivery, including managing the scope of the project and changes to the project deliverables

oProvide Production Support SQL bases applications.

oResponsible for database performance. Configuration, backup and restore procedures.

oManages data warehouse configuration and performance tuning.

oResponsible for :

oMonitoring and tuning of databases/ queries performance

oManaging and supporting SQL databases

oMirroring, Log Shipping and Clustering configurations

oResponsible for DR for SQL Servers

oHelping with logical and physical database design and architecture

oMonitoring and supporting Business Objects XI 3.1.

oCreating stored procedures, tables, views and functions

oCreating and Support SQL Server Integration Services (SSIS) for best practices, scalability and performance

oLeading all Infrastructure related Projects

oSupport application development teams(Including Informatica and Business Object teams) to ensure data designs will operate efficiently once implemented, including overall database design, helping developers tune queries, assigning proper indexes, and the creation of triggers and stored procedures.

oResponsible for the overall configuration management of the database technologies, including initial database installations, upgrades to new product releases and the installation of service packs.

oManage the storage environments for the SQL Server databases, including optimal sizing, monitoring space, requesting additional storage, and providing growth statistics.

oCoordinate application installation.

oCoordinate Maintenance for all SQL Server database applications.

oWorking with an application vendor and project/system leads/managers to ensure that all system upgrades are reviewed, tested and installed.

oInstalling and configuring databases and layered software products with instructions from vendor, as needed.

oManage day to day system needs and ensure that the system and its interfaces are functioning properly and efficiently.

oPerforming system administration and application management tasks.

2004 – 2005 NPD Group Cambridge, MA

SR. DBA

oWorked as a SR. Database Administrator and Project Manager of IT Team

oResponsible for ensuring quality and maintenance of databases and all the IT related projects.

oResponsible for database backup and restore procedures.

oResponsible for :

- Monitoring and tuning of databases

- Managed and supported SQL databases

- Performed logical and physical database design and architecture

- Designed of the integration between Web applications and Database.

- Database analysis and modeling, design, development,

- Applications support for development teams to ensure data designs will operate efficiently once implemented, including overall database design, helping developers tune queries, assigning proper indexes, and the creation of triggers and stored procedures.

- Modification, documentation, testing, and queries tuning

- Creation and optimization of complex SQL queries, stored procedures, views, and triggers and functions

2000 – 2004 Analog Devices Corp. Norwood, MA

Database Specialist/Web Developer

oWorked as a member of an Intranet/Internet web development team whose responsibilities include all stages of software project development, i.e. analysis, design, development, test, and implementation of web-based business solutions utilizing ASP.NET, SQL, VB, SAP and other related technologies.

oManaged and performed data analysis and data conversion

oResponsible for logical and physical database design and architecture

oDesigned, maintained and supported SQL databases, tested, verified database problems with users and vendors, assisted clients with SQL queries.

oCreated and maintained test plans

oDeveloped the supporting database components (e.g. SQL scripts, DTS packages, stored procedures, tables, views, functions.)

oDesigned, developed, enhanced, tested and supported internal Employee Self Service Web applications using Active Directory and Resource Directory systems as the source for the Employee Information, ASP.Net/ ASP, VB.NET/ VB Scripts/Java Script, SQL, HTML

oCreated a test plan and tested all Web Based application for release.

oSupported and Maintained Portal and Share Point Team Sites.

oWorked under Troubleshooting Production problems and communicated effectively with other team members to identify and address problems.

oDeveloped different BATCH and DLL files using FTP, DOS, and UNIX scripts and scheduled them to run on the scheduler basis.

1998 – 2000 TYCO/M/A-COM Corp Lowell, MA

Technical Specialist

oWorked as a member of a SAP development group.

oAnalyze application issues, make design changes and drive the evolution of the application as part of the process of fixing bugs/making enhancements.

oInvestigate and fix problems, and implement functional changes.

oCreated database views and database tables and stored procedures using SQL.

oDeveloped Web pages using ASP/HTML programming.

oCreated SAP/ABAP Reports including Report Painter/Writer.

oDeveloped ABAP Query, tables, views, and transactions, developed BDC Reports

oDeveloped UNIX scripts for SAP reports.

Education

1995 – 1998 University of Rhode Island N. Kingston, RI

Bachelor of Science in Computer Science.

- REFERENCES AVAILABLE UPON REQUEST -



Contact this candidate