Database AnalystLocation: Pierre, SDDuration: Long-termJob DutiesAdminister, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases.Plan, coordinate, and implement security measures to safeguard computer databases. Based on the tech plan prosed, identifying the suitable database management system that fits for.Modify existing databases and database management systems or direct programmers and analysts to make changes.
That involves the modification in existing code using the MDF tools and technology.Designing and planning for Backup and Recovery strategies for newly created databasesClosely work with release management, Infrastructure, project management teams to plan code various deployments on production environments from DBA perspectiveFixing all the bugs that may arise in production DBMS systemDeployment of the enhanced database related modulesResponsible for Troubleshooting and Root Cause Analysis (RCA) of Database production issue and troubleshooting & resolving the problems faced in the testing phase in conjunction with the development team, testing team, networking team and third-party vendorsImplement and maintain Golden Gate replication to provide high availability and Disaster recovery solution for mission critical systemsCreate shell script to monitor oracle golden Gate process statusCoordinate with change management team on schedule changesPerform root cause analysis and implement permanent solutionPreparation of Functional /technical design document and submit document for client approvalInvolve in meetings with project stakeholders to understand and analyze the new requirements, Design, Development activities, testing strategies, Testing supportPreparation of the work breakdown structure for database development/migration/upgrade projects – spelling out the breakdown of the project into tasks and sub-tasksHighlight if there is any slippage in the plan which is laid down at the starting of the projectTo plan successful deliveries within the estimated time bandwidthsRequirementsBachelor's degree with Minimum 5 years of relevant experience or Masters degree with 3 years of relevant experienceBachelor's degree in computer science or relevant field.