I had lead many software projects for private and public sectors, and have worked in diverse IT fields like - software development, various hardware, dealing with different operating systems like Novell Netware, Windows products and Linux with different level of skills starting from installation, configuration and troubleshooting, server administration, database design and administration.
Responsible for the overall redesign and upgrade for Studio Photokina pertaining to IT, specifically the infrastructure - both international and local corporate verticals, handling the overall deployment of Photography Studio ERP platform, for Studio Photokina in Kuwait and Qatar. Integration aspect from other third-party application to have a proper end-to-end flow. Lead the setup of IT infrastructure and deployment of POS application for Art Studio in Kuwait.
Track record of tackling and solving tough business and technical problems. Demonstrated ability to work effectively with individuals at all levels and in all functional areas. Experience in managing full project lifecycle from requirements gathering to final implementation and end-user training.
Adding to that; working with various technologies related to Application Development, Database, IT Hardware, Operating System and Digital Photography Technology (Software and Equipment) gave me a solid experience and wide knowledge.
Devise data strategy that address company's requirements.
Build inventory of data needed to implement the architecture.
Research new opportunities for data acquisition.
Identify and evaluate current data management technologies
Create a fluid, end-to-end vision for how data will flow through the organization
Develop data models for database structures
Design, document, construct and deploy database architectures and applications
Integrate technical functionality
Implement measures to ensure data accuracy and accessibility
Constantly monitor, refine and report on the performance of data management systems
Meld new systems with existing warehouse structures
Produce and enforce database development standards
Maintain corporate repository for all data architecture artifacts and procedures
Expert
Microsoft SQL Server
Design:
Create, move, modify or delete database.
Create SQL statements to create, modify or delete entities in the database.
Security:
Define schemas.
Assign necessary access rights on fields, tables, views and stored procedures.
Maintenance:
Create and monitor scheduled backup tasks for all databases.
Create and monitor scheduled database replication tasks.
Support:
Analyse and modify the data transactions, whenever it is required.
Perform CRUD operations through custom developed application.
Daily Tasks:
Check the daily SQL Server database and transaction log backups and SQL Server Agent jobs for errors.
Check all databases to make sure all are up and not marked as suspect.
Check DBCC CHECKDB for errors.
Check SQL Server and Windows application and system event log entries for warnings and errors and determine if any entries warrant further investigation.
Check mirroring status for all databases being mirrored.
Check for service status for all Windows services that are required for operation.
Look for any security policy violations.
Look for resources on the server, such as file sizes and disk space, and audit growth for long-term projections.
Check system performance levels against established baselines.
Use long-running queries or tasks to generate the data.
Double check that no configuration changes have been made on the server, and if so, document and investigate.
Ensure that all data replication tasks are operating normally.
Record and compare last day of CPU activity with known baseline.
Monthly Tasks:
Check for full system backup status. Verify that the MSDB database is being backed up.
Verify that index and statistic maintenance has completed.
Perform sample restores of database backups on preproduction servers to spot-check backup set integrity.
Examine SQL Server wait statistics to see if new ‘pain points’ have become large points of contention within SQL Server.
Audit job execution time for dramatic variances against baseline runtimes.
Investigate databases for objects that violate established rules.
Verify that SQL Server is sending database mail properly.
Quarterly Tasks:
Compare SQL Server run book specifications against current configuration.
Update run book if necessary.
Perform system maintenance, such as disk defragmentation, Windows updates, SQL Server cumulative updates.
Verify that data access speed is running at normal levels.
Perform full system growth projection update as part of normal capacity management.
Perform a full index analysis for all databases.
Determine unused indexes and disable if appropriate.
Determine missing indexes and investigate process to update or add indexes to better cover data usage.
Review systems for tuning opportunities.
Perform tuning as necessary.
Perform full test of disaster recovery plan.
Perform full system restore against a virtual machine so that all core systems and services can be brought up in isolation and tested for integrity.
Expert
Oracle MySql Server
Design relational database
Perform CRUD operations through custom developed application.
Start and shutdown database server.
Manage and monitor database using mysqladmin administrative client.