In-depth understanding of security and backup procedures to ensure database integrity. Involved in designing logical and physical data models using Erwin.
Performed upgrades from Oracle 9i to 10g. End-user requests in terms of assisting them in effectively create tables, views, packages, sequences, schema refreshes. Utilize Metalink for opening tickets, downloading and applying patches. Louis, MO: Database Administrator Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment. Administration of Oracle Applications versions 11i. Experience in Capacity Planning and Bench Marking.
Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams. Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
Performed large batch jobs, and tuning of SQL queries and database systems. Performed capacity planning for efficient database growth. Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries. ABC Company, St. Responsible for the creation and management of users, roles, profiles, and privileges.
Supporting database management by utilizing upgrade, tuning, and monitoring techniques. Upgraded databases from Oracle 9i, 10g to 11g. Provide technical support for database maintenance and disaster recovery Identify, recommend, and implement all new database technologies and Oracle license management. Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries. Managed users, passwords and account lockouts. Applied CPU patches.
Creation of users and Granting them privileges and roles. Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages. Coordinating Backup and Recovery operations over all databases. Applied Oracle Applications and database patches.
Involved in designing logical and physical data models using Erwin. Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
ABC Company, St. Design, develop, and implement automated data backup and restoration procedures. Installation and configuration of Oracle 9i, 10g databases. Configured scripts to monitor activity with database. Performance tuned assigned databases. Allocate and Manage logical storage structures like Table spaces.