Marisleida Mabin aka Nina US Citizen
Tel: [Send email to request phone number] 24-8794
Commerce Township. MI. 48382
[Send email using form at bottom]
I have a solid Database Administration expertise with SQL Server. I am
responsible for the planning, implementation, configuration, and administration
of relational database management systems. I administer, maintain, develop and
implement policies and procedures for ensuring the security and integrity of the
companys databases. Furthermore, I implement data models and database designs,
data access and table maintenance codes. I resolve database performance issues,
database capacity issues, replication, and other distributed data issues.
EDUCATION PROFILE:
Devry University. Chicago, Illinois. - Bachelor Degree: Technical Management.
Certifications:
* MCP Microsoft Certified Professional
* Brainbench.com Score: 3.93 in SQL Server 2000 Administration. Scored higher
than 91% of previous examinees.
* 70-229 - Certified Professional in Designing and Implementing Databases with
Microsoft SQL Server 2000 Enterprise Edition.
* 70-028 - Certified Professional in Administering Microsoft SQL Server 7.0
* 70-290 - Certified Professional in Managing & Maintaining a MS Windows Server
2003 Environment.
* 70228 - Installing, Configuring, and Administering Microsoft SQL Server 2000
Enterprise Edition.
WORK EXPERIENCE:
aaaaaaa Commerce Twp. MI, USA
Title: SQL Server Database Administrator
Date: Jan 2009 Present
Proactively monitor the production SQL infrastructure environments to ensure
continued availability of the database services.
Deploy maintenance and support actions for the production Windows servers
running SQL services.
Develop processes to increase efficiency and automate regular maintenance of
support actions.
Provide on-call support.
Assist Infrastructure team with testing and implementation of new Service
Packs and hotfixes releases.
Deploy and maintained of Log Shipping.
Frequent interaction and team work with the SAN and Sysadmin team members.
Work closely with the security team to implement database security complaint
with SOX items.
High proficiency in enhancing Microsoft Transaction SQL, including the ability
to create views, functions and stored procedures.
Implement in backup and recovery methods.
Perform system performance measuring and monitoring.
Provide leadership and technical expertise for others in my local team.
Participate in technical discussions
I have been introduced to Data Mart, Data Warehouse and general Business
intelligence system methodologies and deployments. I configure and maintain the
SQL Server configuration for the BI environments.
FEDERAL MOGUL - SOUTHFIELD MI, USA
Title: SQL Server Database
Administrator/Consultant/Designer/Developer
Date: Sept 04. 2008 Dec 2008
I was the only DBA this corporation. I supported over 55 SQL Server machines;
over 100 instances; over 700 databases in this organization global environments.
Designing, building, installing, configuring and supporting Database servers
Applied the following concepts and features: Database Management -, MS SQL
Server 6.5 though SQL Server 2005, SQL Programming, Database Security,
Requirements Analysis, Data Maintenance, Database Performance Tuning, Large
Clustered System Implementation.
Tasks performed included: install, maintain and patch the MS-SQL software;
create, move, upgrade, and delete databases; implement backup and recovery
processes; routine maintenance on databases; performance monitoring and tuning
using Performance Monitor, SQL Server Profiler and Dynamic Management Views;
implement and maintain security rules and security audits; maintain state of
audit readiness; problem resolution.
Deploy and maintained a SQL clustering environment.
Worked with application development staff to develop database architectures,
coding standards, and quality assurance policies and procedures
Maintained a Log Shipping environment. Troubleshoot issues in existing Log
Shipping environments
Monitored database system details within the database, including stored
procedures and execution time, and implement efficiency improvements
Monitored, optimize and requested allocation physical data storage for
database systems
Planned and coordinated data migrations between systems.
RYDER / NETSTAR - NOVI MI, USA
Title: SQL Server Database
Administrator/Consultant/Designer/Developer
Date: August. 2007 July 2008
Designed disk drives to separate data, log, backup files, OS files and misc
files. Labeled disk drives with appropriate identifier names.
Created procedures that finds related objects in databases with does not
explicitly specify Parent-Child as related objects.
Responsible for building/configuring the servers to as SQL Server boxes.
Upgraded SQL server boxes to more powerful boxes. I.e. migrated to Windows server
2003.
Upgraded SQL Server boxes 6.5, 7.0, 8.0 or 2000, 90 or 2005, Installed the
required SQL Server Service Packs
Move system database files including the master database files.
Configured the Tempdb data files to match the current amount of logical CPUs.
Deployed Replication between SQL Server 2005 servers. Also Deployed
replication between SQL Server 2005 and SQL Server 2000.
Implemented and maintain a replication environment. Use SQL Server
Replication utility.
Designed and implement redundant systems, policies, and procedures for
disaster recovery and data archiving to ensure effective protection and integrity
of data assets.
Maintained design structure by directing implementation of SQL 2005 standards
and guidelines.
LA-Z-BOY / DPM - NOVI MI, USA
Title: SQL Server Database
Administrator/Consultant/Designer/Developer
Date: August. 2007 June 2008
Migrated DTS and SSIS packages and SQL Server jobs to new servers.
Created script to extract the logins (usernames), UserIds and their
corresponding encrypted password. When, required, reestablished the logins and
their corresponding credentials in Development and Test environments.
Created utilities such as one that find objects which is a process that
doesnt exist in SQL Server 2005.
Used tools such as LiteSpeed to perform faster backup and restore of large
databases.
Documented and create reports of current configuration of SQL Server boxes by
running system stored procedures such as sp_configure and sp_helpuser. To
achieve this objective, I also used system tables sysusers and sysobjects.
Worked in a cluster server environment
Monitored availability and performance of production databases and servers
Created SQL Server jobs to automated and schedules transfers of large amount
of data(i.e. 5 Terabytes)
Analyzed, tested and implemented database design supporting various business
applications.
I was responsible for and recovery strategy including disaster recovery, load
strategy design and implementation, and security.
Perform backup and restores of individual tables using my own script or using
tools such as LiteSpeed
Used problem tracking tools such as SpotLight, Performance Monitor, Task
Manager and SQL Server
Profiler. Also used maintenance tools such as LiteSpeed and RedGate
MCKESSON - Livonia MI, USA
Title: SQL Server Database Administrator, DBA
Lead/Designer/Tester
Date: April. 2006 August 2007
Confirmed database requirements by conferring with clients; studying
operations and objectives; integrating enterprise requirements; applying database
concepts and functional capabilities.
Met enterprise requirements by planning and developing database structure;
developing database utilization policies, procedures, security, backup, and
recovery.
Reviewed uses cases created by business analyst, review technical
specifications. \ Assessed and developed long-term strategic goals for production
databases in conjunction with data owners and department managers.
Created database physical and logical design
Created and enhanced existing store procedures using tools such as Tuning
Advisor.
Provided server administration support: backup/restore, security access, etc
DBA lead for an offshore DBA team. Provided database requirements and reviewed
deliverables in form of T-SQL code, VISIO design, etc
Participated in a client server application project from its inception to its
test phase.
Performed detailed analysis of database performance using SQL Profiler.
Deployed and taught best practices regarding performance tuning, security and
permissions
Planned database and server level capacity according to statistics and user
requests
Implemented disaster recovery plans with other groups and departments. i.e.
deployed filegroups to contain the database data files. The objective was to be
able to store images in a different drives. Also, the objective was to be able to
backup the files containing the images in a different process and time as the
files containing user data.
VALASSIS / NUSOFT Solutions - Troy MI, USA
Title: SQL Server Database Administrator/Consultant
Date: January. 2006 April 2006
MS SQL Server 2005: SSIS, MS SQL Server DTS. Created, troubleshooted and
maintained DTS/SSIS packages
Database Design VISIO and SQL Server Designer
Perform Database Sizing
Established linked servers used to fetch/load/query external data
Created database Best Practice documents and implement this practice across
the organization
Used T-SQL to create objects such as store procedures, tables and views.
Alternatively, use the Enterprise Manager
GUI to create these kinds of database objects.
Served as consultant to business clients and to Business Analysts
Responsible for identify and improving existing stored procedures and tuning
of slow queries.
Provided 24/7/365 database support.
Database upgrading and installation, creating and managing databases,
continuously enhancing backup and restoration plan, monitoring and
troubleshooting.
FORD MOTOR COMPANY / CIBER - Dearborn MI, USA
Title: SQL Server Administrator
Date: June. 2004 - May. 2005
MS SQL Server Performance tuning.
Database design and modeling.
Acted as developers consultant.
Supported 30 SQL Server client applications - (90 Environments -- QA, DEV, and
PROD).
Make sure that all the code is re-runnabled. If a procedure fails it has to
be rolled backed to a save point i.e. Check if objects exists prior from
querying, updating, or deleting data in those objects.
Work with large scale databases (i.e. 5 Terabytes). Work with high volume,
high profile enterprise database operations
Work with DTS utility
Troubleshoot failing jobs by searching for causes in SQL Server log, Event
Viewer logs and SQL Server Agent logs/history.
|
