Collaborate with Data Analyst and Architects, Developers and Quality Analysts on the physical database design and implementation.
Work directly with development groups helping design SQL to interact efficiently with the database.
Operating System tuning and management.
Performance Monitoring and Tuning: Monitoring and performance tuning on physical server level, database level, Database level (Database settings and options) and query tuning, memory settings, monitoring CPU usage and Disk I/O activity.
Data Extraction, Transformation, and Loading (ETL): Archive and maintain the history data, extract the archived data and make it available to the business.
Disaster recovery implementation.
Business Intelligence Development Studio: Develop Business solutions that include Analysis services, Intelligence services, Integration services, and Reporting services projects.
Security Administration for specific application access and user access
Assist with database capacity planning.
Develops and implements complex data models and logical database designs.
RAC (Real Application Clusters)
Plans and conducts structured testing of database designs to confirm functionality and performance.
Plans and executes testing and implementation of major systems.
