Database Administrator

Home

People

ID : 1432

Education level : Diploma

Work experience level : Expert- (more than year 7)

Work experience in total : Years

Job type : Online

Job time : Maandelijks

Last date of registration :

2022-12-30

I am a hardworking, quick learning new technologies and confident individual. I am able to work both individually and as part of a team. I would greatly appreciate an opportunity to meet you as personal for further discussion regarding my qualifications. Thank you for your consideration and I hope to hear from you in the near future.

Senior Database Administrator - Pearson Pvt ltd, Colombo - (May 2018 to date)

Lead consultant database - Virtusa Corporation, Colombo - (July 2017 - May 2018)

Senior Database Administrator SQL Server and Sybase Company - LSEG (London stock exchange) - (October 2016 - July 2017)

Responsibilities
- Maintain 20 SQL Server instances and 5 Sybase servers.
- Fixing the SQL job issues, make sure drive space and data file and log file size are good. Support Application team member by taking Sybase backup and restore, handle security user roles.
- In UNIX host, manage drive space and manage files. Check errors in log files and fix it. Manage shell scripts. Manage the memory in UNIX hosts.
- Provided 24x7 Remote / on-call production supports.
Environment
- Windows
- UNIX

Database Administrator SQL Server - Ignition-one (content management systems) - October 2012 - October 2016)

Responsibilities
- Managed 7 production SQL Servers located in SAN active and active.
- Servers got 100 of SQL jobs those are having more than 20 databases with around 10 TB each db., rebuild index, make sure the data files log files, temp database are good state., statistics up to date, stored Procedures, Triggers, Functions, Full Back up, Differential backup, Transactional logs backup DBCC Commands, maintain Indexes, Security, sliding windows Tools used for monitor SQL sentry, Jira for change tracking.
Environment
- Windows
- Linux

Database Administrator IBM DB 2 -MAS Solutions (Pvt.) Ltd. - (February 2012 - September 2012)

Responsibilities
- Database design. Manage tablespace, log files. Write efficient stored procedures, views, update statistics design and rebuild indexes. Make sure online offline backups are done correctly. Make sure the memory, CPU usage and drive space are in good state. handled user and security
Environment
- Windows

Database Administrator - Intervawe Solutions (Pvt.) Ltd. - (March 2009 - February 2012)

Responsibilities
- Database design, write efficient stored procedures, views, update statistics design and rebuild indexes. Make surebackups are done correctly. Make sure the memory, CPU usage and drive space are in good state handled user and security
Environment
- Windows

Technology Engineer - Virtusa Corporation, Colombo - (May 2008 - March 2009)

Responsibilities
- Write efficient stored procedures, views and worked in share point applications.
Environment
- Windows

Senior Software Engineer - Mertekinfosys (Pvt.) Ltd, No.3-3/1, Station Rd, Col 3. - (December 2005 - October 2007)

Responsibilities
- Contributed software engineering expertise in the development of products through the software lifecycle, from requirements definition through successful deployment. Facilitated customization of systems by encouraging software engineering team to adopt emerging standards for software application development architecture and tools. using vb,vb.net ,SQL Server ,crystal reports .
Environment
- Windows

Analyst Programmer cum DBA - HTN Information System (Pvt.) Ltd -(March 2001 - July 2004)

Responsibilities
- Contributed software engineering expertise in the development of products through the software lifecycle, from requirements definition through successful deployment. Facilitated customization of systems by encouraging software engineering team to adopt emerging standards for software application development architecture and tools. Using vb.vb.net ,SQL Server ,crystal reports

Support Executive - Profit Point Business Solution (Pvt.) Ltd - (July 1999 - August 2000)

Responsibilities
- Maintaining the Profit Accounting System. (Indian Made)
Environment
- Windows

Operating System
- Windows
- Linux
- ubuntu
RDBMS
- SQL Server 2000 to SQL server 2017
- IBM DB2
- MYSQL
- SYBASE
- ORACLE 11
NO-SQL
- Cassandra
- Mongo dB
Tools
- SSIS
- SSRS
Language
- ASP
- NET
- C#
- VB
- NET
- SQL
- PL/SQL
- VB
Web Technology
- HTML
- XML
Tools:
- SSIS
- SSRS

Professional Certification

Microsoft Certified Professional and MCTS: SQL Server 2008, Implementation and Maintenance.
Administering a SQL Database Infrastructure MCSE 70-764
MCSA: SQL 2016 Database Administration - Certified 2020
AWS Solutions Architect - Associate certification
AWS Certified Database - Specialty
British Computer Society
- Information Systems
- Information Technology