Crop Picture
NOTE: Do not upload any image that violates our Picture Policy. Doing so will result in the removal of the concerned image without prior notification.
概要
An experienced IT professional with database MS SQL SERVER. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products.Currently working in a demanding production support environment managing large volumes of business critical data. A committed team player, self motivated with the ability to communicate at all levels.Presently looking for a suitable database administrator position with a responsible company.
项目
工作经历
Principle Database Engineer
Database engineer
Database Administrator
Installation, configuration and upgrading of Microsoft SQL Server.Establish and maintain sound backup and recovery policies and procedures.Take care of the Database design and implementation.Implement and maintain database security (create and maintain users and roles, assign privileges).Database tuning and performance monitoring.Application tuning and performance monitoring.Setup and maintain documentation and standards.Plan growth and changes (capacity planning).Work as part of a team and provide 7×24 supports when required.Do general technical troubleshooting and give consultation to development team.Developed complex T-SQL code such as Stored Procedures, functions, Indexes and views for the application.Responsible for optimizing SQL queries, stored procedures to improve the performance time.Coordinated with the management to discuss business needs and designed database solutions accordingly.Running synchronization process between production, staging, testing and development environment using Red Gate.Reviewed, optimized, and tuned existing procedures and functions, ensured better performance; monitored server processes, backed up and restored database.Created and maintained hundreds of stored procedures to implement complex business logic.Excellent ability to develop and implement data and reporting solutions.Maintained SQL scripts indexes and complex queries for analysis and extraction.Ensured best practice application to maintain security and integrity of data.Administering data from multiple SQL Server databases.Able to work closely with application and web developers.Create Tables, Table Partitions, and Indexes.Organize and improve functionality of data.Experience writing complex SQL Queries and Procedures.Managed SQL Server Agent Jobs.Writing, updating and supporting reports using TSQL.
Database Administrator and Developer
Installation, configuration and upgrading of Microsoft SQL Server.
Establish and maintain sound backup and recovery policies and procedures.
Take care of the Database design and implementation.
Implement and maintain database security (create and maintain users and roles, assign privileges).
Database tuning and performance monitoring.
Application tuning and performance monitoring.
Setup and maintain documentation and standards.
Plan growth and changes (capacity planning).
Work as part of a team and provide 7×24 supports when required.
Do general technical troubleshooting and give consultation to development team.
Developed complex T-SQL code such as Stored Procedures, functions, Indexes and views for the application.
Responsible for optimizing SQL queries, stored procedures to improve the performance time.
Coordinated with the management to discuss business needs and designed database solutions accordingly.
Running synchronization process between production, staging, testing and development environment using Red Gate.
Reviewed, optimized, and tuned existing procedures and functions, ensured better performance; monitored server processes, backed up and restored database.
Created and maintained hundreds of stored procedures to implement complex business logic in the ERP system modules, such as Human Resource Management, Customer Relationship Management, Operation etc.
Excellent ability to develop and implement data and reporting solutions.
Maintained SQL scripts indexes and complex queries for analysis and extraction.
Ensured best practice application to maintain security and integrity of data.
Administering data from multiple SQL Server databases.
Able to work closely with application and web developers.
Create Tables, Table Partitions, and Indexes.
Organize and improve functionality of data.
Experience writing complex SQL Queries and Procedures.
Managed SQL Server Agent Jobs.
Writing, updating and supporting reports using TSQL.
Database Administrator
Installation, configuration and upgrading of Oracle server software and related products
Evaluate Oracle features and Oracle related products
Establish and maintain sound backup and recovery policies and procedures
Take care of the Database design and implementation
Implement and maintain database security (create and maintain users and roles, assign privileges)
Perform database tuning and performance monitoring
Perform application tuning and performance monitoring
Setup and maintain documentation and standards
Plan growth and changes (capacity planning)
Perform general technical trouble shooting and give consultation to development teams
Interface with Oracle Corporation for technical support.
Patch Management and Version Control
