Database Administrator

/
/
Database Administrator
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
Profile description

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.

Work experience In details :
Job position
Job description

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

 

Hard skills
  • 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
Soft skills
Achievements

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
Special notes

OS: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| With 3 diplomas

Meer person

ID : 2042
Associate Software Engineer
Education level: Bachelor's degree
Work experience level: Intermediate- (2-4 year experience)
ID : 2041
System Engineer IT
Education level: Bachelor's degree
Work experience level: Experienced- (4-7 year experience)
ID : 2040
Associate Engineer
Education level: Bachelor's degree
Work experience level: Associate- (1-2 year experience)
ID : 2039
Intern
Education level: Bachelor's degree
Work experience level: Beginner- (internship- 1 year experience)
Mis geen enkele belangrijke kennisgeving houd jezelf update
Begin met chatten!
Wij staan u graag te woord!
Hallo 👋
Kunnen we je helpen?