Ø General understanding of storage technologies and networking
Ø General understanding of routine maintenance, recovery, and handling failover of a database
Ø General understanding of AWS and AWS RDS.
Ø Ability to maintain strict levels of confidentiality in handling sensitive information
Ø Eager to learn new skills and techniques to improve my efficiency at workplace
Ø Ability to communicate effectively across different channels and departments
Ø Flexible, willing to take on more responsibilities as needed, and devote time necessary to complete deadlines
Ø Monitoring and optimizing the performance of the database
Ø Allocating system storage and planning future storage requirements for the database system
Ø Document the company’s database environment
Ø Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
Ø Configuration of SQL Server merge or transactional replication
Ø Configuration of SQL Server transactional & Merge replication
Ø Configuration, Creation, maintenance, updates and troubleshooting of SSIS and SSRS
Ø Allocating system storage and planning future storage requirements for the database system
Ø Ensure all database servers are backed up in a way that meets the business Recovery Point Objectives (RPO)
Ø Test backups to ensure we can meet the business Recovery Time Objectives (RTO)
Ø Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
Ø Performs data analysis and other reporting tasks. This involves data investigation and cleansing.
Ø Designed and implemented stored procedures for certain certification
Ø Data migration from other databases (FoxPro, Access, Med Soft) to SQL Server through SQL (Import/Export) wizard or by scripting complex queries as well
Ø Worked on the data import for the Acquisitions getting signed up with FUSION LOGIC
Ø Day to Day, weekly and monthly Reporting
Ø Mail Server Configuration
Ø Query Optimization, Roles and weekly maintenance with schema changes
Ø Delivered database deployment through the whole system lifecycle