Description
Professional Summary Over 15 years of MS SQL Database Administration experience in Implementation, Designing, Development, Testing and Production support in various industries including Oil and Gas, Financial, Telecommunication, Energy, Medical and Manufacturing. * Extensive experience in installation, configuration, upgrading and maintenance of Microsoft SQL Server, Software products and features. * Worked with developers and other infrastructure team member with regards to accommodating new functionality of database interfaces. * Great technical skills in version migration and upgrades. * Experienced in close coordination with developer staff to create, configure and manage various database objects including tables, indexes, sequences, functions, procedures, packages, triggers and facilitating work of developers by resolving issues that might impede their ability to get their work done in time. * Expert in creation and maintenance of user security, managing users, their security privileges and accesses. Configuration and auditing of SQL Server Security in line with business requirement, manage server logins-user accounts and passwords along with database object permissions- Client/server Connectivity. * Ability to establish and maintain sound backup and recovery/restore policies and disaster recovery procedures to meet the business Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO). * Scheduling the backups for Databases and Transaction log, perform restoration operations proficient in high availability. Set up database Replication models (Snapshot, Merge, Peer to Peer and Transaction), Log Shipping, Clustering and Mirroring on Physical and Virtual machines.