Creating stored procedures, triggers, and functions
Generating codes to extract, transform, and load data from miscellaneous (e.g. XML, flat files...) data sources to SQL Server or Non-SQL Databases
Perform on-going tuning for the database engines and instances to improve performance.
Plan and implements backup and recovery for the database to protect data against any failures.
Reporting required statistics to upper management.
Creating database integration processes between multiple DB engines and objects.
Good knowledge of console application and web applications.
Mentor and develop junior team members of system engineers as required.
Pro actively monitor system capacity and produce regular capacity planning reports to show current systems capacity utilization and growth trends, to add capacity as needed.
Take lead in resolving operational issues, perform root cause analysis, and implement necessary corrective actions to prevent re-occurrence.
Install, upgrade, monitor, and maintain the relevant Database to keep it at high level of availability.
Identify and recommend database techniques to support business needs.
Troubleshoot problems regarding the databases, applications and development tools to keep the high level of systems availability and data consistency.
Maintain the relevant database high availability and disaster recovery procedures using HA tools that manage different DB nodes access and undertake better availability.
Administer all database objects, including tables, clusters, views, sequences, packages and procedures.
Create and manage multiple databases and assist in capacity planning.
Maintain data integrity and security (manage roles and permissions of database users).
Support operation team by responding to operation incidents and service requests.
Setup and maintain database infrastructure for the company’s BI and reporting needs.
Create detailed documentation including diagrams of database infrastructure.
Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
Reviewing current systems, and Presenting ideas for system improvement.
Make sure a database is operational, and providing valid and relevant data.
Establishes networking environment by designing system configuration; directing system installation; defining, documenting, and enforcing system standards.
Maximizes network performance by monitoring performance; troubleshooting network problems and outages; scheduling upgrades; collaborating with network architects on network optimization.
Secures network system by establishing and enforcing policies; defining and monitoring access.
Reporting network operational status by gathering, prioritizing information; managing projects.
Ensure security of data, network access and backup systems
Act in alignment with user needs and system functionality to contribute to organizational policy
Configuring and installing various network devices and services (e.g., routers, switches, firewalls, load balancers, VPN, QoS).
Performing network maintenance and system upgrades including service packs, patches, hot fixes and security configurations.
Troubleshoot and resolve problems encountered by end users of various areas such as, desktop systems, user’s applications, ERP applications, co-location network communications, Internet and other computer technology.
Fixing problems and proactive to in trying anticipate likely problems, find malfunctions, interruptions or network such as communications, revision levels, compatibility, configurations and capacities.
Installing, configuring, maintenance and troubleshooting network systems.