SQL
Ad ID: J-27016
Posted on 4 Apr 2014 5:56 pm
Viewed 232 times
Category: | IT/Computer Hardware/Software/Network |
Salary: | Negotiable |
Will apply for: | Work Permit |
Contact no.: |  |
Email: |  |
Job Description: | Job responsibilities "
• Provide MSSQL database administration service.
• Following standard team processes and defines new ones with corrections.
• The individuals will be expected to be fully-functional DBA’s who can perform traditional DBA activities independently and guide team members too.
• Able to provide escalation support whenever required.
• From an operational perspective, responsibilities include troubleshooting problems, working maintenance windows and providing 24x7 on-call supports on a rotational basis.
• Pre-installation Tasks
• Installing Oracle Server and Patch Mgmt
• Installing & Maintaining DB Tools
• Uninstallation
• Database Upgrade
• Database Migration
• Database Patch Installation
• Physical Database Design and Implementation
• Database Setup
• Database Clean up / Removal
• DB Cloning
• Start up and shutdown of Database instances
• Maintaining Database replication / standby / clusters
• Job scheduling
• Verify all Instances are running
• Look for any new alert log entries
• Verify that SNMP is running
• Look for Trace files
• Session Monitoring
• Query or Transaction monitoring
• Lock and Latch monitoring
• Activity / Redo Log monitoring
• Job monitoring and Purging Job history
• Replication / Stand by monitoring
• Object Monitoring
• Verify free space in table spaces
• Verify rollback segments
• Reorganization of DB to remove fragmentation
• Rebuild of indexes
• Analyze of objects
• Purging of DB logs and trace files
• Verify that Server has enough resources for acceptable performance
• Periodic Report Generation on Database Health
• Identify bad growth projections
• Identify space-bound objects
• Review contention for CPU, memory, network, and disk resources
• Generating statistics
• Look for objects that break rules.
• Ensure that all indexes use an index table space
• Ensure that all tables have unique primary keys.
• Look for harmful growth rates
• Examine tuning opportunities.
• Look for I/O Contention
• Review fragmentation by investigating row chaining and other areas of fragmentation
• Database Objects Creation / Review
• Check for unusable indexes
• User / Schema Creation
• User Management
• Roles and Privileges Management
• Look for security policy violations
• Look in Net8 logs for errors and other issues
• Privileges & Access controls on Database
• Verify that the database archiving to tape was successful.
• Verify that the database backup was successful
• Backup execution and monitoring
• Archive all alert logs to history
• Conduct Backup , restoration drills for backup verification
• Database Connectivity issues
• Slow response
• Operations timed out
• Database incident and error resolution
• Archiver Process Stuck
• Database incident and error resolution
• Vendor Management
• System Performance Monitoring
• Maintaining Environment details
• Shell Scripting for DB related work
• Adherence to Change Management Process
• Presales knowledge / experience are added advantage.
• Implement ITIL processes & Create Transition Management Dockets
• Provide MSSQL database administration service.
• Following standard team processes and defines new ones with corrections.
• The individuals will be expected to be fully-functional DBA’s who can perform traditional DBA activities independently and guide team members too.
• Able to provide escalation support whenever required.
• From an operational perspective, responsibilities include troubleshooting problems, working maintenance windows and providing 24x7 on-call supports on a rotational basis.
• Pre-installation Tasks
• Installing Oracle Server and Patch Mgmt
• Installing & Maintaining DB Tools
• Uninstallation
• Database Upgrade
• Database Migration
• Database Patch Installation
• Physical Database Design and Implementation
• Database Setup
• Database Clean up / Removal
• DB Cloning
• Start up and shutdown of Database instances
• Maintaining Database replication / standby / clusters
• Job scheduling
• Verify all Instances are running
• Look for any new alert log entries
• Verify that SNMP is running
• Look for Trace files
• Session Monitoring
• Query or Transaction monitoring
• Lock and Latch monitoring
• Activity / Redo Log monitoring
• Job monitoring and Purging Job history
• Replication / Stand by monitoring
• Object Monitoring
• Verify free space in table spaces
• Verify rollback segments
• Reorganization of DB to remove fragmentation
• Rebuild of indexes
• Analyze of objects
• Purging of DB logs and trace files
• Verify that Server has enough resources for acceptable performance
• Periodic Report Generation on Database Health
• Identify bad growth projections
• Identify space-bound objects
• Review contention for CPU, memory, network, and disk resources
• Generating statistics
• Look for objects that break rules.
• Ensure that all indexes use an index table space
• Ensure that all tables have unique primary keys.
• Look for harmful growth rates
• Examine tuning opportunities.
• Look for I/O Contention
• Review fragmentation by investigating row chaining and other areas of fragmentation
• Database Objects Creation / Review
• Check for unusable indexes
• User / Schema Creation
• User Management
• Roles and Privileges Management
• Look for security policy violations
• Look in Net8 logs for errors and other issues
• Privileges & Access controls on Database
• Verify that the database archiving to tape was successful.
• Verify that the database backup was successful
• Backup execution and monitoring
• Archive all alert logs to history
• Conduct Backup , restoration drills for backup verification
• Database Connectivity issues
• Slow response
• Operations timed out
• Database incident and error resolution
• Archiver Process Stuck
• Database incident and error resolution
• Vendor Management
• System Performance Monitoring
• Maintaining Environment details
• Shell Scripting for DB related work
• Adherence to Change Management Process
• Presales knowledge / experience are added advantage.
• Implement ITIL processes & Create Transition Management Dockets
• Root Cause Analysis for DB problems/ Recurring problems and initiate Request for Change
"
Skill required "
At least SQL DBA experience, 4+ years required
• Thorough Knowledge of Windows Operating System
• Knowledge of creating and maintaining standby / replication setup
• Strong in SQL fundamentals
• Knowledge of using Enterprise Manager and Query Analyzed for basic administration
• Knowledge of configuring and setting up maintenance activities for DB
• Knowledge of SQL statements tuning and DB Tuning
• Knowledge on DB structures (file groups, Indexes - clustered /non clustered/fillfactor)
• Knowledge on Memory structures (configurable parameters)
• Knowledge of complete /differential / transactional backups and their recovery scenarios
• Knowledge on High Availability configuration like replication and log shipping
• Excellent communication Skills
• Prior experience in a 24x7 environment desired
• Strong analytical and troubleshooting skills.
• Provide on-call support as and when required
• Team player who has a customer focus and brings expertise to the team
"
Qualification ·Â
As per the Project Requirement.
Additional Qualification / Skills "
• MCSE MSSQL Certification is mandatory
• Technically sound knowledge on Clustering, Log Shipping, Mirroring
• In depth Knowledge on SQL server 2000, 2005, 2008 Versions. "
Personal Attributes "• Accepts Responsibility
• Openness
• Positive attitude
• Integrity
• Commitment
• Judgement
• Organized
• Proactive "
Location : Yangon
|
