Compiles technical specifications using templates andstandards as set by managementDesigns complex data modelling structures using T-SQL and SQL servertools.Makes changes and enhancements to current systems following SDLCand corporate governanceEnsures that customer/user specifications are met through thedevelopment and delivery of working programs to quality standard, andwithout bugs by carrying out complex program debugging and systemtestingEnsures… Show more Compiles technical specifications using templates andstandards as set by managementDesigns complex data modelling structures using T-SQL and SQL servertools.Makes changes and enhancements to current systems following SDLCand corporate governanceEnsures that customer/user specifications are met through thedevelopment and delivery of working programs to quality standard, andwithout bugs by carrying out complex program debugging and systemtestingEnsures supporting documentation is in placeApplies security principles to all design and development work performedDefines implementation/cut over approach requirements and steps to beFollowed (implementation/cut over plan). This will include consulting theBusiness on business readiness criteria.Conducts system analysis and impact analyses of new development asWell as changes or fixes prior to development taking place.Ensure that only approved software and applications are installed on PC`s including Operational Systems.Designs and presents prototypeAnalyses, identifies and resolves system problems. Documents work donefor future reference.Assesses current system efficiency and makes suggestions in respect ofoptimal use of computer systems and applications.Provides testers with background and insight relating to processes andfunctionality provided.Gives technical input and advice on new development and changes tocurrent systemsFacilitates joint design sessions with Testing and Business Analyst staffConsultant to ABSA, give advice with respect to Jemima project and assist with deployment of software as well as software changes to Production. Assist ABSA testers with DEV and UAT test cycles.Schedules, conducts and reports on code reviews including correctiveaction identified to ensure minimum standards are followedApplies version control to all development and associated documentationProvide support and resolve issues around application in accordance withSLA. Show less

• Assist Solution Architect in Projects and Infrastructure Preparations.• Change Approver for CA Service Desk (Changes migrating to Production)• Setup Win 2008 R2 Application Server and SQL Server 2008 R2.• Installation of Terminal services and configuration of Server Features and Roles.• Folder shares and Authentication through SMB on ABSA Domain.• Printer Installation, Sharing and Authentication.• Routing from Server \ Absa Domain to DVR private network and from… Show more • Assist Solution Architect in Projects and Infrastructure Preparations.• Change Approver for CA Service Desk (Changes migrating to Production)• Setup Win 2008 R2 Application Server and SQL Server 2008 R2.• Installation of Terminal services and configuration of Server Features and Roles.• Folder shares and Authentication through SMB on ABSA Domain.• Printer Installation, Sharing and Authentication.• Routing from Server \ Absa Domain to DVR private network and from workstations back to Server.• Configuration of IIS for ISA mobile interface.• Installation of SQL Server 2008 R2• Configuration and Administration.• SQL replication. • Exposure to Log shipping• Run Patches and Scripts. • Data Manipulation with T-SQL scripting.• Troubleshooting Maestro Database• Creating logins and users• Maintenance on Database indexesCrystal Reporting• Developing small user interface reports for cash centres.• Implementation of ISA Application at ABSA.• Install and configure of ISA on Cash centres across SA• Driver Installations of Counting machines.• ODBC Configurations for Applications.• CCTV Interfacing with ISA Infrastructure.• Track and Trace Interfacing and Configuration.• Standard Deposit and Order Interfacing and Configuration.• ISA Mobile Configuration.• Configuration of ISA:• Full on Testing of application on site.• Scanner programming for specific barcodes.Implementation of TTL Application at ABSA• Setup Win 2008 R2 Application Server and Progress Database• Installation of Terminal services and configuration of Server Features and Roles.• Folder shares and Authentication through SMB on ABSA Domain.• Scanner programming for specific barcodes.UAT Environment• Responsible for Lab Environment and load fixes that passed DEV phase.• Ensure that UAT is always aligned with Production Environment within the Lab.• Prevent changes from going into production that was not signed off at Business level. Show less

SQL SIDESQL Implementer SQL SERVER 2008 R2 Installations. Configuration and Administration.SQL replication. Exposure to Log shippingRun Patches and Scripts. Data Manipulation with T-SQL scripting.Troubleshooting Maestro Database (ISA Application Database)Creating logins and usersISA SIDEImplementation of ISA at ABSA, FNB and STANDARD BANK.Install and configure of ISA on Cash centres across SADriver Installations of counting… Show more SQL SIDESQL Implementer SQL SERVER 2008 R2 Installations. Configuration and Administration.SQL replication. Exposure to Log shippingRun Patches and Scripts. Data Manipulation with T-SQL scripting.Troubleshooting Maestro Database (ISA Application Database)Creating logins and usersISA SIDEImplementation of ISA at ABSA, FNB and STANDARD BANK.Install and configure of ISA on Cash centres across SADriver Installations of counting machines.ODBC ConfigurationsSetup Terminal Server on Server 2008 R2.Network sharing.CCTV InterfacingTrack And Trace InterfacingStandard Deposit and Order Interfacing.Configuration of ISA:Add new cash centres to ISAConfigure Security, Configuration, Definition rules, Deposit Rules, Clients, Interfaces, System Rules and System Config.Updating of Isa program with Patches. Installing of reports Show less

Implementation of Car Dealership Software at all major dealerships.Setup of Servers.Implementation of SQL and DB.Customer support.Implementing security on databases. Creating Logins with necessary Permissions Backup And Restore Procedures. Using SQLCMDMaintenance and Performance Procedures. Maintenance scripts Using SQLCMDOptimizing Performance using DMV’s. Adding necessary Indexes or removing unwanted Indexes.