Pavan DBA's Blog

The DBA Knowledge Store

Oracle DBA [5-7 yrs]

Posted by Pavan DBA on June 3, 2012

Database Administrator – Ixia IT

Location – Kolkata  / Bangalore
Job Description:  Database Administrator will administer, maintain, develop and implement policies and procedures for integrity and operation of the company databases. Implement data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues.

• Optimizes stored procedures and queries
• Documents, updates and maintains database backup and recovery strategy
• Creates scripts for restoring security settings and each database
• Documents all Database Server software installations before moving to Production. Documents all changes made to Database Production Servers
• Creates Database Maintenance and Automated Alerts
• Evaluates and recommends tools to monitor Database Server Software
• Chooses counters and conditions to monitor and creates Monitoring Templates
• Defines the monitoring schedule and creates automated jobs for common monitoring tasks
• Analyzes monitoring reports and looks for performance trends
• Responds to system alerts and provides problem details to other staff
• Key member of the disaster recovery team, documents, updates and maintains database recovery procedures for DR
• Creates, optimizes, and monitors Database File Groups and transaction log files and placement

• 5-7+ years’ experience as SQL Server
• Familiar with all versions of Microsoft SQL Server; Oracle & MySQL a plus
• Ability to perform a variety of tasks sometimes simultaneously
• Good communication skills present information and respond to questions
• Meet the deliverables on time by effectively balancing the time spent on production support functions and the assigned enterprise level and internal projects
• Extensive experience with DTS/SSIS & TSQL; PLSQL a plus
• Familiarity with the following a plus:
o Informatica
o Cognos

Interested Candidates , pls. mail us at



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: