CONTD FROM H.10B performing SQL Server and Oracle database administration in a financial services environment.br br Education and Experiencebr br Bachelors degree or foreign education equivalent in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three 3 years of experience in the job offered or three 3 years of experience performing SQL Server and Oracle database administration in a financial services environment.br br Or, alternatively, Masters degree or foreign education equivalent in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and one 1 year of experience in the job offered or one 1 year of experience performing SQL Server and Oracle database administration in a financial services environment.br br Skills and Knowledgebr br Candidate must also possessbr br Demonstrated Expertise DE creating parallel replicated or disaster recovery databases, using Microsoft SQL server database mirroring and log shipping technologies; and testing disaster recovery scenarios for performance, functionality, recovery time, and point objectives, using SQL Server Management Studio, SQL Database Mirroring, and AlwaysOn technologies.br br DE performing database administration of SQL Server and Oracle databases using SQL Server Management Studio; and setting up, installing, and managing Oracle replication technologies Oracle GoldenGate ActiveActive and ActivePassive and Oracle Data Guard.br br DE performing database SQL tuning and troubleshooting realtime mission critical database applications using Oracle Enterprise Manager; and identifying bottlenecks and providing performance tuning and optimization recommendations based on Oracle AWR, ASH, and SQLT reports and system diagnostics.br br DE in database architecture designing relational database physical data models and performing capacity planning, indexing, partitioning, archiving, and database compression using SQL Server Management tools; and designing and implementing enhanced database monitoring and alerting solutions, using SQL Server monitoring tool and Oracle Enterprise Manager.
Categories: eb3
0 Comments