Installed, configured and administrated Microsoft SQL Server 2005 Enterprise Edition, designed and maintained security for Microsoft SQL Server 2005, implemented Database Mirroring to support High Availability and configured Log Shipping to off load report data for SQL Server 2005, designed and maintained Microsoft Windows 2000 Network Infrastructure, created custom reports via SSRS, designed, created and maintained Client Tier applications written in Visual Basic and VB.Net, SQL Server 2005 stored procedures, and XML.
- Institute of Computer Management
- Financial Estate Planning
Confidential,GA 02-99 to 03-10
Title: Systems/Database Administrator
Duties: Migrate SQL Server 7.0 databases and objects to SQL Server 2005 Enterprise Edition while enforcing data quality according to business requirements imposed by laws, and regulations set forth by the company, accomplished by analyzing business and regulatory requirements, determining exceptions, establishing requirements for quality data, and working closely with developers to ensure that all applications enforce data quality. Implement BIDS to design and construct SSIS Packages utilizing ETL while automating administrative functions. Implement a schema change policy with the DBA’s and developers to maintain schema management. Create constraints, triggers, views and stored procedures to insure data integrity and normalization. Design and administer SQL Server 2005 security by maintaining a server level and user level security strategy. Monitor, tune and optimize the new system during parallel processing utilizing Profiler, DTA, System Monitor and developing baselines while creating detailed documentation of all aspects of successes and anomalies. Implement Database Mirroring on mission critical databases to support High Availability. Configured Log Shipping to off load report data for remote users. Create ad hoc reports, and predefined reports via SSRS. Implement a Disaster Recovery Plan and Backup Strategies. Set up and maintain E-Mail accounts via SQL Server 2005 Mail.
Title: Contract Programmer
Duties: Emulate software originally created in “WANG” and converted to Visual Basic 6.0 Enterprise Edition utilizing SQL 7.0 Stored Procedures to store and retrieve college student’s credit card information.
Title: Database Administrator
Duties: Responsible for Design Configuration and Implementation of a Microsoft Access database, set-up database back up and recovery, monitor database performance, diagnose problems and administer database security.
Confidential,PA 1-96 to 08-97
Title: Contract Programmer
Duties: Perform analysis, designed, created, documented and maintained a software package written in Visual Basic 4.0 to replace the Back Office Procedure’s of the Billing department originally created in COBOL.