| Healthcare Center of California, Sacramento, CA |
| Senior Database Administrator, Data Quality Monitoring System |
- Worked with a team of four database administrators
- Provided support for historical database of Medi_Cal encounters
- Developed Statistical Process Control driven quality monitoring process
- Worked on to detect any data anomalies induced by data handling procedures
- Also worked on reporting a profile of batch submittals
- Worked on a large database of 2 TB
- Designed physical and logical database layout
- Created catalog tablespace, regular tablespace, temporary tablespace, index tablespace on different containers and raw devices
- Involved in a complex exercise of porting 180 millions of records from mainframe to AIX machine using the DB2load utility, Unix Ksh scripts, Fileport,Ftp
- Estimated tuning parameters using benchmark testing methods
- Used web designer to add users, change privileges and set printers
- Upgraded various technical documents and manuals
- Monitored servers on 24X7 basis for potential problems and performance issues
|
| Environment |
| Aix v (4.3), DB2 UDB EEE (6.1) Control Center, Tera_Term, Fileport, C Ftp and Scripts use Korn Shell, Web Designer, IBM OS390 Mainframe, Erwin 3. |
