Aleksandra Skoko Despenic

Aleksandra Skoko Despenic

סרביה
פרילנסר
 צור קשר

אודותינו

Head of Database Unit at Serbian Custom Service
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

Windows Server Failover Clustering

Microsoft Serbia
  • Windows Server Failover Clustering
ינואר 2013

SQL Server 2012: AlwaysOn High Availability and Desaster Recovery Solutions

Microsoft
  • SQL Server 2012: AlwaysOn High Availability and Desaster Recovery Solutions
נובמבר 2011

Optimisation Service Center-Workshop

IBM
  • Optimisation Service Center-Workshop
ספטמבר 2008

IBM ES52-z/OS Programming Workshop

Serbain Bussiness Systems
  • z/OS Programming Workshop
יוני 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

• BSc in Physics with specialism in sciences for Physics

University of Pristina, Serbia