Oracle Security
Resume:
Salman Ansari
Mobile: 647-***-****, Toronto, Canada
Email: ***************@*****.***
Sr. Oracle DBA
** *****+ of total IT experience.
Analytical and detail oriented IT Professional with over 15 years+ of progressive North American work experience augmented by formal education and core skill certifications. Expertise lies in analysis and design of highly available and scalable databases systems supporting mission critical transactional and reporting applications. Skilled in the design, implementation, tuning and maintenance of large and complex databases. Adept communicator, strong interpersonal skills, ability to serve as a liaison between business and technical staff. Strengths include ability to work in fast paced work environments like a support center/data center, work with teams in an on-shore and off-shore environment across multiple time zones, and manage multiple projects concurrently or one big project of a highly complex nature. Strong team player and ability to work with professionals of diverse technical and non-technical backgrounds. Global perspective of work and life based on extensive experience of working in diverse cultural environments.
CORE SKILLS
Core DBA
Performance tuning
Capacity planning
Upgrades
Large Environments
Infrastructure Support
Technical documentation
Risk assessment
Data center support
Communication skills
Disaster recovery planning
Problem solving
Multitasking
Team Player
Change control procedures
Project planning
EDUCATION
Bachelor of Electronics Engineering – Osmania University, Hyderabad, India Graduated 1992
CERTIFICATIONS
Oracle Certified Professional – Oracle 8, 8i, 9i, 10g, 11g and 12c.
PROFESSIONAL EXPERIENCE
Sr. Oracle DBA Consultant Jul 2017 – Till Date
Interac, Canada
Working with a team of over 4 DBAs in a supporting IT services to one of the largest financial services provider in Canada.
Work with the team to support DBA operations for various flavors of Oracle, MySQL and MS SQL adhering to SLA. Planned and executed upgrades of databases from version Oracle 11g to Oracle 12c in various production and non-production RAC and non-RAC databases. Implemented new 12c feature of Oracle Multitenant option to consolidate databases.
Monitor the database for capacity and performance using tools like grid control and cloud control 12c to ensure database systems work efficiently. Promptly resolved any issue that could arise out of such monitoring.
Work with various teams/stake holders on various phases of projects like planning, execution, troubleshooting, deployment and ongoing support. Upgraded OEM 12c to OEM 13c.
Install, configure, patch and monitor databases on various flavors of Linux using tools like OEM 13C.
Perform routine database tasks like db builds, installation, upgrades, user management, RMAN backups/ restores and index rebuilds. Implemented SQL plan baselines and profiles to provide plan stability.
Proactively check AWR/ADDM/ASH reports for performance optimization opportunities. Check application databases for security and integrity. Support various flavors of SQL Servers databases (2008-2016).
Work with various teams like to coordinate application of critical (and regular) patches to Oracle and SQL Server environments, comply with internal and external audits reviews and implement architecture designs to comply. Install, patch and upgrade Oracle Grid Infrastructure and database.
Implement Oracle Advanced Security Options like Transparent Data Encryption TDE (tablespace/column) and wallet.
Installed and managed a high availability environment using Oracle Active Data Guard and Golden Gate and Oracle Cloud Control 12c and Cloud Control 13c (OEM 12c/OEM 13c).
Sr. Oracle DBA Consultant Aug 2016–Jun 2017
BMO Card Products
Worked with a team of DBAs in managing a database infrastructure supporting Oracle in a data center, clustered, virtualized environment servicing various clients/business units across multiple time zones.
Ensured any production related problems are promptly resolved within the SLA and provide regular updates to the stake holders if needed. Upgraded databases from Oracle RAC (Oracle Real Application Cluster) 11g to 12c using ASM (Automatic Storage Management), upgrades of Oracle Siebel and Oracle BI Publisher. Implement Oracle wallet security (Oracle security management). Support various tools IBM WebSphere/IBM Business Process Manager. Implement Oracle security features like wallet and encryption of tablespace/column.
Worked closely with managers, team leads, project and operations/solutions delivery teams, vendors and subject matter experts to deliver projects on time. Worked on various version of engineered systems like Exadata X2 and X3. As part of DRP strategy test Oracle backup and recovery scenarios.
Ensured storage, archiving, backup and recovery procedures are documented and periodically checked.
Implemented in-memory databases to speed up ETL cycle in the data warehousing environment. Archived data using the information lifecycle management. Migrated databases from Solaris to Linux on new hardware.
Work with the business users in understanding and documenting the requirements of new projects, manage and coordinate deployment of such enterprise wide projects. Working knowledge of ZFS. Setup OEM 12c and 13c.
Check with the customers/clients on the quality of service being delivered, take steps to mitigate and improve any short comings. Daily validate the environments for performance, availability and capacity planning.
Tracking and reporting on the status of projects, identifying/resolving issues and ensuring the quality of deliverables.
Built strong working relationships and rapport with data architecture, IT infrastructure and application development teams. Checked alerts and database logs for any issues and resolve them. Experienced in database and program code performance tuning like memory, buffer pools, CPU, locking, sorting. Implement Oracle database vault and data redaction. Working knowledge of various offering of Oracle Cloud. Encrypted RMAN and data pump backups.
Moved dozens of databases from Dell Servers to Amazon RDS cloud computing environment.
Used Golden Gate and Data Guard to provide a high availability environment. Working knowledge of Hadoop, Mongo DB and PostgreSQL. Used ITIL tools like Remedy to service incidents, problems and changes.
Sr. Oracle DBA
IBM May 2015–Mar 2016
Telstra
Worked as part of a team supporting mission critical databases across South America and Europe.
.
Work with the management in implementing SOX and ITIL processes. Took steps to enforcing security for all of the Oracle Databases. Used GroundWork and TSM to monitor the databases. Perform required analysis to resolve complex technical issues
Upgraded and Migrated databases from Oracle 10.x to Oracle 11.x. Supported and Upgraded Oracle OPA
Implemented hot backup and created standby databases for critical applications to ensure 24x7 availability.
Migrated databases from Windows to Linux. Exposure to Oracle Siebel. Configured Oracle Management Repository for OEM 13c.
Participate in on-call pager rotation to provide support to production systems outside business hours.
Migrated from file system storage to Automatic Storage Management. Handle database security requests in development, test, production and disaster recover environments
Liaised between production/development team and Oracle Corp in creating, escalating and resolving Tars.
Estimate resources, do capacity planning design, document and implement numerous projects across various lines of businesses using tools like OEM (Oracle Enterprise Manager), TOAD and SQL Developer.
Experienced in working with Oracle databases on physical, virtual, cloud and RAC environments.
Deliver assigned projects on time working in cooperation with various teams and vendors.
Diagnosed and resolved any technical issues to restore business operations in a timely fashion.
Planned and implemented Data Guard to ensure there is minimal down time to production databases.
Sr. Oracle DBA Feb 2012–Jan 2015
DB1
Provide user access based on the job function taking into consideration the corporate security guidelines and data standards.
Review recurring production issues and investigate root causes and alleviate such issues.
Keen interest in knowing newer and evolving technology and study/evaluate to see if such technologies can help IT deliver better services to the business. Provide technical assistance to application team for utility usage and problem resolution. Setup OEM 13c metrics.
Plan and implement migration from Oracle9i to Oracle10g/Oracle11g on various platforms like Linux, Solaris, HP-UX, AIX and Windows Server.
Run periodic security scans to make sure the users are having the required permissions and privileges.
Worked with various teams to make sure that the Oracle systems are highly efficient and scalable.
Perform risk assessment for security patches and apply them to ensure that highest security level is maintained. Implemented OEM using grid agents. Served as technical lead for projects of short duration.
Develop and implement disaster recovery plans (DRP) by conducting impact analysis and identifying and fixing any gaps. Participated in the architecture review process for development projects.
Worked with developers to ensure the overall application design is optimal using Oracle table partitioning and materialized views. Provide input on the technical design of applications. Ensured optimum use of software facilities and features; walk through critical components.
Experienced in open source software like Nagios and openfiler.
Follow through with Oracle support and other vendors for any technical issues/challenges and take steps to mitigate and remediate such issues.
Sr. Oracle DBA Dec 2005 – Apr 2011
Tangerine (formerly ING Direct Bank)
Worked for the largest provider of financial services in Canada supporting various lines of businesses.
Worked with a team of DBAs to maintain a high performance and available infrastructure.
Highly motivated, non-adversarial and friendly style of working with the teams to solve problems and provide excellent customer service.
Coordinated project related activities with customers/stake holders at all levels according to project requirements.
Worked with teams to support the infrastructure stack that consisted of multiple layers like Oracle application servers, IBM Web sphere, Siebel, Informatica.
Upgraded and Migrated databases from Oracle 9.x to Oracle 10.x.
Used SQL profiles to implement plan stability as part of performance tuning.
Estimate resources, design, and document and implement numerous projects across various lines of businesses.
Sr. Oracle DBA Mar 2005 – Dec 2005
Davis + Henderson
Worked for the largest provider of financial services in Canada supporting various lines of businesses.
Worked with the UNIX and storage team to design, build and manage highly available and scalable database infrastructure.
Tuned instance parameters and also SQL and PL/SQL to optimize performance.
Wrote shell scripts for routine DBA tasks - dump/reload, rebuild indexes, analyze tables, free space report, extent allocation report, coalesce tablespaces, monitor alert log.
Participated in application deployments, releases, patches and such regular DBA related activities.
Sr. Oracle DBA Jun 2003 – Mar 2005
CIBC World Markets
Supported more than a dozen lines of businesses across Canada and US for CIBC world markets that included Wood Gundy, Wealth Management, Toronto stock exchange and NY stock exchange.
Implemented coding standards for the PL/SQL programs, debugged, tested and deployed with a focus on scalability and performance.
Supported Oracle 8.x databases and also Oracle parallel Server (OPS). Migrated and upgraded databases from Oracle 8.x to Oracle 9.x.
Migrated from OPS to Oracle 9.x RAC using Veritas Cluster file systems.
Participated and Contributed in non-development/configuration activities, namely but not limited to, documentation updates, presentations, testing plan development, project quality check points, etc.
Implement Oracle security features like profiles and wallet security. Perform space analysis on tablespaces and do reorg as required.
Working knowledge of other databases like MS-SQL Server, Sybase, DB2 and MySQL.
Contact this candidate