Team Leader Database Administrator , ITIL®
ITSC
Total des années d'expérience :14 years, 6 Mois
1- Design and document database architecture. Data Modeling.
2- Design Data Warehousing and Business Intelligence platform
3- Build database scheme, tables, procedures and permissions
4- Excellent experience with T-SQL and performance impact .
5- Develop database utilities and automated reporting.
6- Create, test and execute data management languages.
7- Analyze and sustain capacity and performance requirements.
8- Analyze, consolidate and tune database for optimal efficiency.
9- Oversee backup, clustering, mirroring, replication and failover.
10- Restore and recover corrupted databases.
11- Set up data sharing and disk partitioning.
12- Provide 24/7 support for critical situations.
13- Evaluate and recommend new database technologies.
14- Knowledge on High Availability configuration like replication and log shipping
15- Strong experience Working on ETL Tools .
14- Very Good experience Working on SSRS .
15- Very Good experience Working on SSIS .
16- Strong analytical and troubleshooting skills.
17- Working on Database Upgrade & Database Migration
processes .
18- Knowledge of complete /differential / transactional backups and
their recovery scenarios.
As a MSC Data Analyst, I'm part of the List Pull factory and participate on an MSC execution team by
performing complex SQL queries and large data extraction and manipulation tasks using only Microsoft SQL Server
only. Also, as marketing campaigns complete, you will aid in the delivery of standard reporting metrics to MSC
customers. You will report to a MSC Marketing Manager and the Data factory lead. The ability to communicate
effectively in English is a requirement of this position.
- Working on data manipulation and extraction using Microsoft SQL Server Management Studio 2008 :
o Working with query fundamentals, tables and views
o Working with strong and complex queries as well as with stored procedures
o Implement Sub queries and Common Table Expression Queries
- Create some local databases, views, table and workflows in order to standardize and industrialize the data
- Using SQL Sever BI (SSIS & SSRS)
- Using ETL Tools
- Data manipulated are mainly PII (Personal Identifiable Information) like name, company name, phone
numbers, e-mail addresses, job titles, etc.
- Combining of data files for use of suppression or enrichment (Combining of different outputs format to aid in
targeting)
- Responsible for timely execution of marketing activities as defined by SLAs (Service Level Agreements).
- Attendance, completion, and participation in new tool deployments, updates, and trainings as required.
Current job description at METLIFEALICO as Database Administrator:-
• SQL Server auditing - control direct database access to production databases and monitor Omni Audit reports.
• Troubleshoot performance issues on Compass and B1MCO Applications.
• Configure and schedule Database and Transaction log backups
• Monitor regular backups
• Perform database maintenance tasks - monitor database growth, shrink log files, etc.
• Replication - configure and monitor replication between B1MCO and eClaims servers
• Provide overall supervision of all administrative database environments.
• Establish the needs of users and plan data-flows for a new or revised database
• Map out the 'conceptual design' for a planned database and consider both 'back end'
Organization of data and 'front end' accessibility for end users
• Implement physical data structures into database
• Implement data standards across all databases, including MetLife Database and Data
Classification standards .
• Write and maintain database documentation, including definitions for the data dictionary
('Metadata').
• Control access permissions and privileges on databases
• Develop and implement database backup and recovery procedures and ensuring they are
Functioning correctly
• Communicate regularly with technical, applications, and operational staff, to ensure the
Database integrity and security.
• Installing new applications as well as assisting in debugging of problems as needed.
• Support I TAG web application databases (Case 360) after training with RSTN Company.
(Nov 2011 - Sep 2012) was working at TEPCO COMPANY as Database Administrator SQl Server 2005 and ERP system Administration Microsoft Dynamics GP 10 and responsible for Backup system, troubleshooter for ERP System GP10 and automation job and Database Performance
I was responsible for managing SQL Server Databases, including increasing its performance and moving data from site to another, also I was doing the typical DBA tasks like Backup, Replication, Mirroring, and Auditing.