Senior Database Administrator/ Manager -Applications
HADI CLINIC
Total years of experience :25 years, 3 Months
• Administration and Implementation of databases with Microsoft SQL Server 2008, Microsoft SQL Server 2012 and SQL Server 2000(Database size is more than 300 GB) in Windows Cluster 2008 R2 and VMware ESX i 5.
• Administration and Implementation of COGNOS 10.1 and COGNOS 8.4
• Administration and Implementation of IBM System X servers and storage.
• Administration and Implementation of Windows Servers .
• Administration and Implementation of database with Oracle 12c.
• Administration and Implementation of Hospital Information System (HIS) software applications.
• Plan, design and develops databases.
• Database performance tuning for achieving high scalability and speed.
• Troubleshooting and optimizing using SQL Profiler
• Plan and Implement data mart for Cognos.
• Create and Implement ETL process with SSIS.
• Manages database growth for all databases.
• Create and maintain up-to-date documented database backup for all databases.
• Create and maintain up-to-date documented database recovery strategy all databases- (Log shipping and disaster recovery plan)
• Migration of database to new version.
• Develops and maintains stored procedures/database scripts .
• Implement and monitors database activities and completion SQL Jobs.
• Plan, coordinate and implement security measures to safeguard database.
• Define and monitor users and user access rights of database
• Ensures data integrity, accuracy and data remains consistent across the databases.
• Interacts well with other technical staff, such as networking to ensure connectivity and compatibility between systems.
• Interacts well with users of functional areas as well as with software developers and suppliers.
• Participates in the testing of new applications
• Writes database documentation, including data standards, procedures and definitions for the data dictionary .
• Provides technical support for outdated 'legacy' systems.
• Giving training to Trainers and application users
• Configure the intranet site of Hadi Hospital.
• Prepare reports in Crystal Report and link it with application software.
• Prepare management report as per the requirement of TOP management
• Trouble shooting Server Hardware related issues.
Implementation, Maintenance and Supporting Database of BauBit.
System Analysis and Design new modules in BauBit.
Plan, design and creation of database.
Involved in the design of Procedures, Triggers and Indexes.
Creating new Modules and adding new features in BauBit
Developing GUI using Delphi.
Creating patches for users requirement.
Involved in preparation and execution of Unit and System Testing
Involved in low-level design document preparation.
Design and Implementation of Database in Microsoft SQL Server 7.0
Involved in design of Procedures, Triggers and Indexes.
Developed GUI using Visual Basic 6.0.
Involved in preparation and execution of Unit and Integration Test Plan.
Controlling all technical departments.
Implementation and administration of NIIT's Intranet network (TechEdge).
Administration of network users (Windows NT 4.0, Unix, LINUX ),
database users (Sybase, Oracle 8).
Reporting to Regional Head Office about Technical Compliance.
Imparting of training course for new recruits.
Assigning projects, helping students in requirement analysis, designing, coding and testing.
Master of Computer Application (MCA) from Maduri Kamaraj University Maduri,India.