Aleksandra Skoko Despenic
סרביה
פרילנסר
אודותינו
Head of Database Unit at Serbian Custom Service
Government Administration
Government Administration
שפות
אנגלית
שליטה קרובה לשפת אם
תחומי התמחות
תכנות ופיתוח תוכנה
DB - IBM DB2
DB - MSSQL, SQL Server
נסיון תעסוקתי
נובמבר
2004
-
היום
Head of database management unit-Lead IT Systems Engineer-DBA
Serbian Customs , Belgrade, Serbia- : Head of database management unit responsible for-DB2 on z/OS mainframe, DB2 on AS400/iSeries and SQL Servers
- • Database and system administration, installation, implementation, maintenance, troubleshooting, tuning and technical support
- • Monitoring and tuning database performance and improvement through database modification and change,
- • Database backup and recovery strategy using IBM utilities ensuring integrity and recoverability of database structures
- • Collaborative working with system engineers to oversee varied technical specialties,
- • Collaborative working with application team members in designing, creation and support to ensure correct physical and logical design through all phases of application testing. Transforming logical models into physical data models,
- • Analyze application SQL and access paths for performance improvement opportunities ,
- • System and database analysis,
- • Replication and migration of databases across platforms,
- • Providing DB2 and operating system technical support and optimization,
- • Benchmarking DB2 standards, controls and procedures,
- • Planning and coordinating test environments, creating testing scenarios and documentation,
- • Enforcing database integrity and security protocols
- • Creation and maintenance of appropriate detailed design documents, data flow diagrams and data entity relationship documents for all internal projects,
- • Monitoring DB2 processes, objects and logs for any anomalies and providing corrective actions,
- • Generation of snapshots and data base realted information,
- • Training and mentoting DBA in local enironemnt protocols and proactices
- • 24X7 production support
פברואר
1998
-
נובמבר
2004
IT Systems Engineer
National Statistics Office of Serbia , Belgrade, Serbia- Duties: To act as IBM z800 mainframe systems engineer and PL/I programmer
- • IBM z800 mainframe systems engineer,
- • Leading programmer on Borland Delphi environment,
- • Leading programmer on IBM OS390 mainframe under DB2 environment and PL/I language,
- • OS/2 network and WinNT administration,
- • Interface with business analysts & developers with regards to application,
- • Design and implementation of new statistical information system which combines all the research. Define requirements for data processing,
- • Make standards and instructions which regulate the connection of the statistical departments and ICT Center
קורסים, הסמכות, לימודי תעודה
ינואר
2017
SQL Server 2012 Performance and Optimisation
Microsoft Serbia- SQL Server 2012 Performance and Optimisation
ינואר
2013
SQL Server 2012: AlwaysOn High Availability and Desaster Recovery Solutions
Microsoft- SQL Server 2012: AlwaysOn High Availability and Desaster Recovery Solutions
יוני
2008
IBM ES66-Securing OS/390 for e-business
Serbian Bussines Systems- IBM ES66-Securing OS/390 for e-business
מאי
2007
IBM DB2 UDB for z/OS Application Data Recovery
Serbain Bussiness Systems- IBM DB2 UDB for z/OS Application Data Recovery
אוקטובר
2006
IBM DB2 Stored Procedures Programming Workshop
Serbain Bussiness Systems- IBM DB2 Stored Procedures Programming Workshop
דצמבר
2005
IBM DB2 UDB for z/OS Application Performance Tuning
Serbian Bussiness Systems- IBM DB2 UDB for z/OS Application Performance Tuning
אוקטובר
2005
IBM DB2 UDB for z/OS System Administration
Serbian Bussiness Systems- IBM DB2 UDB for z/OS System Administration
תארים אקדמיים
אוקטובר
1990
-
יוני
1995