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.
概要
Proficient in database administration, database management, analysis, design, development and reporting. Expertise in database optimization & performance tuning, backup, recovery, database auditing, security implementation, server configuration and maintenance with troubleshooting capabilities. Hands-on experience on administering SQL Server High Availability and Disaster Recovery solutions like Clustering, Replication and Mirroring.
Expertise in T-SQL writing stored procedures, triggers and functions. Upgraded production and development environments from SQL Server 2008 R2 to SQL Server 2012 and then 2012 to SQL Server 2014 and SQL Server 2016.
Effective usage of monitoring tools, like Ignite and Solarwinds to troubleshoot the performance and slowness issues related to Web and application Servers.
I have started my career with Oracle Database Administration 11g from 01/01/2018. My areas of specialization are Oracle Databases 11g, High availability solutions especially (Data Guard) on Linux/Unix.
I am always keen to work in a challenging and motivated environment to get more expertise. My commitment is always with quality of work related to my job. I understand my responsibilities and business need of employers. I believe in honesty, hard work and discipline
项目
工作经历
Lead Database Administrator
· Installation, configuration of Oracle Database 11g, 12C on Oracle Linux, Redhat, Oracle Linux & other Oracle server software and related products
· Working on Oracle Tools Toad & Oracle SQL Developer
· Oracle Database Administration 11g
· Implementation of Oracle Data Guard (Physical/Logical/Active) Technology on Windows and UNIX family.
· Implement and maintain database security (create & maintain users & roles, assign privileges)
· Perform backup and Recovery using RMAN. Command on Export, Import and Data Pump.
· Responsible for maintenance and support for company 24/7production database.
· Take care of the Database design and implementation
· Scheduling Crontab Jobs & Password Policy Periodically in Oracle 11g.
· Create Users, Grant, Revoke Responsibilities in Oracle 11g
· Daily Monitoring of Production Servers
· Reset Password of Users in Oracle Apps & Reporting to concern Departments.
Lead Database Administrator
• Create a secure production infrastructure with multiple resources across different platforms. • Design, and scale infrastructure. • Architect and build continuous deployment pipelines. • Create tools to empower developers to manage production infrastructure. • Upgraded development, UAT & Production environments from SQL Server 2008 & 2012 to SQL Server 2014 & 2016. • Developed & implemented enterprise wise automated maintenance infrastructure. • Automated DBA’s daily tasks like Index rebuild & reorganization, and weekly maintenance for statistics updates. • Installation, configuration, up-gradation and migration of systems. • Capacity planning for DB Servers, and recommendations for hardware upgrade, and change in architecture. • Managing deployments on development, staging and production environments. • Designed & implemented database backup & recovery SOP for all databases, i.e. Production and development. • Configured and administered Database replication with Mirroring
• Disaster recovery of databases and SQL server
Lead Database Administrator
· To perform day-to-day database system administration, including daily checklists, backup verification, log review, security maintenance, performance tuning (analysis, indexing, etc.).
· Create, update and maintain database objects in coordination with our reporting team.
· Create, review and maintain code in our database systems to optimize, standardize and/or prepare for upgrades.
· Perform data/database/process consolidations as coordinated with applicable internal staff.
· Upgrade, configure and maintain server and database monitoring software to baseline system performance and proactively identify (and remedy) potential issues. Resource monitoring and capacity planning.
· Review, test, update and document detailed disaster recovery/business continuity plans for key production SQL Servers (database mirroring, log shipping, replication, clustering) in a VM/SAN environment.
· Performs database backup and recovery as required, including periodic testing.
· Reviews, tests, recommends and installs upgrades of database software, including patches and major releases.
· Ongoing review and completion of trouble tickets related to the database systems.
· Train and mentor junior team members on process and technology.
· Performs data analysis and other reporting tasks. This involves data investigation and cleansing.
· The primary duties of this position occur during business hours; however, there is some weekend work related to projects, planned maintenance, and on-call support. Administer database replication among global servers.
· Implemented and administered replication on production servers between multiple datacenters spanning different geolocations.
Senior Database Developer
· Good experience with Reporting Services,
· Create functions, scripts, stored procedures and triggers to support application development.
· Design, develop and implement database systems based on customer requirements.
· Develop database tables and Views.
· Participate in database design and architecture to support application development projects.
· Troubleshoot database related issues in a timely fashion.
· Develop best practices for database design and development activities.
