Rss

Suresh P

Database Administrator - 20 Years of Experience

Occupation:

Database Administrator

Education Level:

Bachelor

Will Relocate:

YES

CollapseDescription

PROFESSIONAL SUMMARY Professional, trustworthy database administrator with specialized knowledge and an exceptional work ethic. Known for dedication and a commitment to protecting databases that are critical to company business. Loyal, logical and focused on applying his skills to enable a company to grow. ACCOMPLISHMENTS * Created one of the largest Oracle data warehouse databases in the Midwest region, and used ETL techniques to load data quickly and efficiently. Result: Enabled business leaders to run reports, analyze information quickly, and make timely decisions. Later migrated the same large Oracle data warehouse database into Netezza, a data warehouse application that enabled faster running of analytical reports. * Restored and recovered all corrupted Production databases with the internal DBA team, using Oracle. Simultaneously replaced a faulty memory module for a fortune 500 company. Result: Recovered database expediently, preventing damage to company business and reputation. * Addressed multiple day waits to run a query, delaying decision-making. Initiated work with development teams and guided the writing of efficient code, allowing applications, reports and queries to run faster. Result: Through use of partitioned tables, efficient indexes, materialized views, and analytical functions, queries were tuned to run within hours, enabling upper management to make timely decisions. * Identified and resolved potential problems by creating proactive monitoring solutions, writing UNIX shell scripts. Set required alerts on Oracle Enterprise Manager, sending alerts to DBAs when a threshold was breached or a database was down. Result: Significantly reduced unforeseen issues and system down times. * Actively upgraded and patched Oracle databases, vital for the organization which was using Oracle RDBMS. Result: Halted security threats.

Right_template4_bottom

CollapseWork Experience

Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseJob Skills

Left_template4_bottom

CollapseKeywords

Left_template4_bottom