Senior Database Administrator
confidential
Total des années d'expérience :17 years, 7 Mois
- Administer, install, and troubleshoot issues for Ms SQL Server 2012, 2014, 2016
- Design, develop, and evaluate high availability database (Always ON Availability Group)
- Design, Planning, and create for Disaster Recovery (DR)
- Design and test backup and restore plan
- Create and implement database virtualization and consolidations strategies.
- Evaluate and harden database security, Implements and enforces security for all of the Databases.
- Implements and assess routine database maintenance plans.
- Creates and maintains all databases required for development, testing, and
Production usage
- Developed complex reports multi-functioned, labeled and grouped, summary functionality in main reports providing detailed drill down through On Demand Sub-reports
- Migrate Date from Oracle DB system to Sql Server DB.
-Administer, install, and troubleshoot issues for Oracle and Ms SQL Server
-Design, develop, and evaluate high availability database (Always ON Availability Group)
-Design, Planning, and create for Disaster Recovery (DR) and oracle data Gard
-Design and teste backup and restore plan
-Create and implement database virtualization and consolidations strategies.
-Evaluate and harden database security, Implements and enforces security for all of the Databases.
-Implements and assess routine database maintenance plans.
-Define, analyze and design database projects, construct conceptual schema and define the function analysis of the system.
-Worked heavily with relationship database models, schemas & entity- relationship diagrams (ERMs) to create technical/system design documents.
-Creates and maintains all databases required for development, testing, education and
Production usage.
-Developed complex reports multi-functioned, labeled and grouped, summary functionality in main reports providing detailed drill down through On Demand Sub-reports
• applying the data cleansing role and create data models
• using several data analysis and data governance techniques
• Established physical data base parameters.
Coded SQL data base descriptions and specified identifiers of SQL data base to data base management system or directs others in coding data base descriptions.
• Calculated optimum values for SQL data base parameters, such as amount of computer memory to be used by data base, following manuals and using calculator.
• Specified user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data.
-Specified which users can access data bases and what data can be accessed by user.
-Tested and corrected errors and refined changes to data base.
-Entered codes to create production data base.
-Selected and entered codes of utility program to monitor data base performance, such as distribution of records and amount of available memory.
-Directed programmers and analysts to make changes to data base management system.
-Reviewed and corrected programs.
-Confered with coworkers to determine impact of data base changes on other systems and staff cost for making changes to data base.
Modified data base programs to increase processing performance, referred to as performance tuning.
• Administer, install, and troubleshoot issues for Oracle and Ms SQL Server
• experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Created Tables, Views, Constrains, Synonyms, Sequences.
• Manage technical issues related to database, applications, and tools used in development process
• Handle database performance tuning, security, capacity planning, and space management
• Administration Task like installation, backup and recovery (Imp, Exp) Checking Database Performance tuning, user privileges, space management., applying update and security patches and all related administration tasks
• Plan and implement backup and recovery strategies
• Provide 24/7 support for critical database issues
• Creates and maintains all databases required for development, testing, education and production usage.
• Performs the capacity planning required to create and maintain the databases
• Performs ongoing tuning of the database instances.
• Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
• Implements and enforces security for all of the Databases.
• Performs database re-organizations as required to assist performance and ensure maximum uptime of the database
• Define, analyze and design database projects, construct conceptual schema and define the function analysis of the system.
• Worked heavily with relationship database models, schemas & entity-relationship diagrams (ERMs) to create technical/system design documents.
• Developed complex reports multi-functioned, labeled and grouped, summary functionality in main reports providing detailed drill down through On Demand Sub-reports
• Load the data from MS Excel, Flat files, MS- access and Oracle Table
• Updating exist database by data we received from our other branches
• Transform the database from access to Oracle 9i
• Start building application to be used in the all branches to insert update the data into the database
