Database Specialist Active Directory
Resume:
Mansfield, MA *****
Phone 508-***-****
E-mail: ********@*****.***
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 and support of business applications. Expert 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 2012/2014/2016/2017/2019, SQL LiteSpeed/TSM, Relativity, 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
Proficient in Application support
Excellent in Workflow Design
Familiar with ITIL concepts and practices.
Experienced with Development support tools, primary with Jira and TFS
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 2012/2014/2016/2017/2019 (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.
Proficient in Relativity Administration
Expertise with SQL syntax including, stored procedures, functions, views, triggers, queries and DTS/SSIS packages.
Proficient in Replication – Snapshot, Merge and Transactional.
Proven experience management of multi-terabyte Clustered systems using Always On, Active-Passive and Active-Active Clustering.
Experience with implementing Database Disaster Recovery and Planning
Proficient with ETL tools and processes, primarily with SSIS 2012/2014/2016/2017/2019.
Experience supporting and deployment of complex SSIS packages.
Skilled in database monitoring and tuning techniques including query optimization, indexing and SQL server configuration.
Proven experience lead complex, time-critical IT work and facilitate activities between the business and IT during inception through delivery.
Experience in testing of all products from developers for release.
Experience with Business Objects, SQL LiteSpeed backup.
Proficient eDiscovery experience in an eDiscovery vendor environment
Proficient in Supporting Relativity environment
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 Salesforce, 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, ColdFusion, Microsoft Webpart and .NET framework, SQL, VB Scripts, PowerShell and JAVA Scripts.
Experienced with Microsoft SharePoint Portal Server, Microsoft Team Service, document management and collaboration tools.
Experienced in UNIX Shell Scripting, UNIX System Programming.
Solid knowledge of Windows 2012/2016/2019.
Employment
4/2017 – Present Forensic Risk Alliance, Providence RI
DBA/Application Support Manager
Build and maintain Review systems and infrastructure across FRA’s global footprint
Document and present solutions to Product Management & Stakeholders
Collaborate with a team of software developers to integrate applications
Participate in day-to-day troubleshooting and resolution of issues
Plan, design, implement and manage database servers across the enterprise
Continuously manage, monitor, and update database architectures as business needs
Work with the Infrastructure team to schedule and perform database server maintenance across the enterprise
Perform Microsoft SQL administration tasks, including backups and restores, database management, and issue troubleshooting
Perform SQL and Relativity scripting for backend support functions
Act as FRA’s liaison with Relativity Customer Support
Perform file migration procedures and monitor processing stages
Load data into SQL databases, Relativity, and other database platforms
Analyze data and processing results, applying analytical skills and logic, to ensure consistency, completeness and accuracy
Provide mentoring and assistance to junior members of the team
Provide reporting and summaries and perform analysis and statistical reporting on client data
Work at the direction of and in collaboration with senior members of the team in order to complete tasks as defined by the client and/or senior members
Collaborate with team members to identify, trace, and solve data anomalies during processing, including the generation of custom solutions
Manage multiple, simultaneous priorities and requests
Support clients and team members which may necessitate travel and/or availability in early mornings, evenings, and weekends
6/2016 – 12/2016 Home Site Ins. Boston, MA
Sr. Project Manager/Sr. DBA
Responsible 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
Installed and configured databases; layered software products with instructions from vendor as needed
Managed day-to-day system needs and ensured that the system and its interfaces are functioning properly and efficiently
Performed SQL Server Administrator, System Administration, and Application Management tasks
Responsible for overseeing, maintaining, and improving database monitoring
Managed the resolution of complex database related issues and outages
Consistently used development support tools like JIRA and TFS
Ensured that processes and documentation were adequate and effective to meet specifications and audit requirements
Worked with vendors and application support teams to gather information; determining and implementing resolutions
Responsible for all aspects of project delivery, including managing the scope of the project and making changes to project deliverables
Ensured that approved IT requests were ushered through the life-cycle process on time and to scope
Acted as an evangelist and mentor for the software development life-cycle and actively promoted ongoing improvements
Monitored tasks on an ongoing basis, evaluated progress and quality, managed project plans, issue and risk tracking and resolution, and taking corrective action as necessary
Maintained liaising with stakeholders on technical, management, and budgetary matters
Conducted kick-off to communicate individual roles and project deliverables, met regularly with team members to ensure project execution is on-track through delivery
Responsible for prioritization, ownership, tracking, and resolution of all database related incidents and requests to meet SLA requirements and development goals
Motivated and inspired other team members to ensure they have the tools and training required to perform effectively
Anticipated stakeholder needs and proactively developed solutions to meet them.
3/2014 – 6/2016 Capgemini Marlborough, MA
Sr. DBA Lead/Sr. Consultant Delivery Team Leader
Responsible for supporting all aspects of hosted MS SQL databases in production environment(s) located in corporate data centers.
Responsible for database performance, migrations, configuration, backup and restore procedures.
Responsible for BI and ETL processes.
Responsible for mentoring the team and ensuring that work is coordinated efficiently across multiple Offshore and Onshore team members
Responsible for monitoring, maintaining, and performance tuning of databases, stored procedures and SQL scripts ensuring the highest levels of data availability and performance.
Responsible for prioritization, ownership, tracking, and resolution of all database related incidents and requests to meet SLA requirements and development goals.
Responsible for SQL Server Replication, Mirroring, Log Shipping, AlwaysOn and Clustering configurations.
Manage the resolution of complex database related issues and outages.
Responsible for DR for SQL Servers.
Collaborate with application in Infrastructure teams to solve database level issues including availability and stability of database environments.
Provide assistance in creating PowerShell script for recurring tasks.
Troubleshoot and analyze problems and identify alternative solutions.
Develop technology tasks required to successfully deploy, implement and support a customer solutions.
Consistently used Development support tools like JIRA and TFS
Communicate technical information to non-technical personnel, vertically and horizontally within an organization.
Setup and constantly improve maintenance, operational and monitoring processes
Responsible to oversee, maintain, and improve databases monitoring.
Monitor and optimize physical storage for database systems
Managing offshore resources in a 24x7 environment
3/2013 – 3/2014 Autopart International. Norton, MA
Sr. DBA
Provide SQL Server optimization and performance tuning for JD Edwards Enterprise One and POS applications.
Responsible for database performance, configuration, backup, migration and restore procedures.
Responsible for ETL and BI processes.
Provide assistance in creating PowerShell script for recurring tasks.
Responsible for monitoring, maintaining, and tuning of databases and SQL server scrips ensuring the highest levels of data availability.
Responsible and manage SQL Server development
Collaborate with application in Infrastructure teams to solve database level issues including availability and stability of database environments.
Responsible for Mirroring, Log Shipping. AlwaysOn and Clustering configurations
Responsible for DR for SQL Servers
Provide performance tuning of other purchased and in-house developed SQL Server applications
Create, optimize and tune Stored procedures, views and functions
Implement SQL server enhancements and updates to ensure technology is current.
Provide development and production support for complex SSIS packages
Implement enhancements to the company major reports and SQL updates process
Coordinate Maintenance for all SQL Server database applications.
Monitor and optimize physical storage for database systems
Develop and evolve the logical and physical database design for our application
Provide optimization and performance tuning for all database designs
Design, develop, and implement data warehouse solutions using SQL server or other applications.
Responsible for prioritization, ownership, tracking, and resolution of all database related incidents and requests to meet SLA requirements and development goals.
Work 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 LEAD
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.
Provide Production Support SQL bases applications.
Responsible for database performance, configuration, backup and restore procedures.
Coordinate the work efforts of local and offshore technical resources.
Responsible for monitoring, maintaining, and tuning of databases, SQL Scrips ensuring the highest levels of data availability.
Provide assistance in creating PowerShell script for recurring tasks.
Responsible for creating stored procedures, views and functions
Responsible for prioritization, ownership, tracking, and resolution of all database related incidents and requests to meet SLA requirements and development goals.
Responsible for :
oMirroring, Log Shipping and Clustering configurations
oResponsible for DR for SQL Servers
oHelping with logical and physical database design and architecture
oMonitoring and supporting BI processes.
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
Support 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.
Responsible for all aspects of ETL and BI processes.
Responsible for the overall configuration management of the database technologies, including initial database installations, upgrades to new product releases and the installation of service packs.
Manage the storage environments for the SQL Server databases, including optimal sizing, monitoring space, requesting additional storage, and providing growth statistics.
Coordinate application installation.
Coordinate Maintenance for all SQL Server database applications.
Working with an application vendor and project/system leads/managers to ensure that all system upgrades are reviewed, tested and installed.
Installing and configuring databases and layered software products with instructions from vendor, as needed.
Manage day to day system needs and ensure that the system and its interfaces are functioning properly and efficiently.
Performing system administration and application management tasks.
Responsible for mentoring the team and ensuring that work is coordinated efficiently across multiple team members.
2004 – 2005 NPD Group Cambridge, MA
SR. DBA
Worked as a SR. Database Administrator and Project Manager of IT Team
Responsible for ensuring quality and maintenance of databases and all the IT related projects.
Responsible for database backup and restore procedures.
Responsible 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
Worked 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.
Managed and performed data analysis and data conversion
Responsible for logical and physical database design and architecture
Designed, maintained and supported SQL databases, tested, verified database problems with users and vendors, assisted clients with SQL queries.
Created and maintained test plans
Developed the supporting database components (e.g. SQL scripts, DTS packages, stored procedures, tables, views, functions.)
Designed, 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
Created a test plan and tested all Web Based application for release.
Supported and Maintained Portal and Share Point Team Sites.
Worked under Troubleshooting Production problems and communicated effectively with other team members to identify and address problems.
Developed 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
Worked as a member of a SAP development group.
Analyze application issues, make design changes and drive the evolution of the application as part of the process of fixing bugs/making enhancements.
Investigate and fix problems, and implement functional changes.
Created database views and database tables and stored procedures using SQL.
Developed Web pages using ASP/HTML programming.
Created SAP/ABAP Reports including Report Painter/Writer.
Developed ABAP Query, tables, views, and transactions, developed BDC Reports
Developed 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