Might be available
(Updated 2023-11-22)SQL Server Database Expert
Dhaka, Bangladesh
Intermediate English
- 20+ years experience in SQL statement tuning, optimize, loading processes.
- 20+ of Experience in MS SQL Database Administration
- 20 Years experience in SQL programming
Skills (43)
DATA ENTRY
STORED PROCEDURES
MS SQL Server
SQL Server
PERFORMANCE ANALYSIS
MAINTENANCE
Microsoft SQL Server
DATABASE ADMINISTRATOR
SQL SERVER 2008
PROBLEM-SOLVING
Database Design
SQL SERVER 2005
DATABASE
OPERATIONS
MICROSOFT WINDOWS
SQL QUERIES
PROCESS IMPROVEMENTS
SQL
LIFE CYCLE
DATABASE MODELING
BUSINESS REQUIREMENTS
ADO.NET
SECURITY POLICIES
MS ADO
SOPS
TECHNICAL DESIGN
DATA INTEGRITY
MySQL
DATA MODELS
Account Maintenance
TRANSLATING
Account Development
USER EXPERIENCE
SWITCH CAPACITY
CAPACITY PLANNING
WORKPLACE SAFETY
Oracle
Temperature and Humidity
QA
PURCHASING
WORK FLOW
BUYING/PROCUREMENT
SQLite
Summary
Respected [Job Title] with history of creating system architectures that reduce
costs and streamline operations. Ready to create design plans from whole cloth
or tackle revamps of disparate networks full of outdated systems. Uses emerging
and nascent technologies to create stress-free operations both on site and via
remote locations and online.
Professional Experience
2014-03 - Present
● Developed modular layer components for use in customized database structures, tailoring individual layers to dataset types and business goals.
● Created Standard Operating Procedures (SOPs) for Extract, Transform, Load operations.
● Gathered, defined and refined requirements, led project design and oversaw implementation.
● Generated customized architecture specifically optimized for several database technologies.
● Created multi-site system architecture plans to reduce redundancy across entire organization.
● Migrated numerous legacy systems to newer technologies, reducing costs and enhancing efficiency of computing tasks.
2011-02 - 2014-02
● Generated customized architecture specifically optimized for several database technologies.
● Designed data models for complex analysis needs.
● Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
● Reviewed clients' overall app and infrastructure estate, business priorities and success criteria to design transformation plans.
● Employed Software-as-a-Service (SaaS) and Platform-as-a- Service (PaaS) products to reduce initial outlay in systems purchasing.
● Planned and installed upgrades of database management system software to enhance database performance.
● Mobile App design and life cycle development and charging integration ● Established software development life cycle to assure the quality of all programs and procedures.
● Developed Reporting tools for management decision.
● Developed 61 SQL databases on 13 individual servers according to operators and wap/web applications.
● Crated Schema, Database Maintenance Plan, Cluster/non- Cluster Indexes and Constraints ● Created Complex T-SQL Queries and Store Procedures and functions for Applications ● Designed and maintained database management system and security policies.
● Distribute work among the developers/engineers and fixed the timelines.
● Coordinate with foreign partners and local partners.
2010-10 - 2013-01
● Identified plans and resources required to meet project goals and objectives.
● Achieved project deadlines by coordinating with contractors to manage performance.
● Planned, designed, and scheduled phases for large projects.
● Met project deadlines without sacrificing build quality or workplace safety.
2009-04 - 2010-09
● Created service level agreement for IT operational functions and help desk operations.
● Inspected equipment, assessed functionality and optimized controls.
● Guaranteed successful technical upgrade projects for clients by collaborating with developers for integrations.
● Overall maintenance of CMS of RHD to ensure full compliance with the existing MIS ● CMS support team to ensure the proper functioning of the systems.
● Covers system maintenance at RHD support center as well as its field offices.
● Maintained and further developed Tender Module.
● Maintained and further developed Project Monitoring Module.
● Maintained and further developed Finance Module with the existing MIS.
2007-01 - 2009-03
● Created service level agreement for IT operational functions and help desk operations.
● Inspected equipment, assessed functionality and optimized controls.
● Guaranteed successful technical upgrade projects for clients by collaborating with developers for integrations.
● Coordinated efficient large-scale software deployments.
● Met architecture compatibility and guidelines through effective troubleshooting.
● Developed clear specifications for project plans using customer requirements.
● Developing Database architect, Process, work flow and implementing Central Management System and Financial Management System (CMS and FMS) application for 82 field divisions RHD- HQ, different project offices throughout the country.
● Create Procedures, Functions, user defined tables, Triggers, User level access, resolution of CMS complaint issues and support issues.
● As a SQL database administrator DBA, regular backup databases, manage logins, permissions of users; manage devices; databases maintenance and optimization; writing complex T-SQL query for application and various customization reports. Configure local, Link and remote server; ● Optimization and maintenance RHD MSSQL databases (CMS, FMS Organization DB, RMMS, BMMS, Tender, PIMS, and so on web-based application.
● Create INDEX, Truncate Log, Define Primary and foreign keys for relational databases, Performance monitor, tuning Index.
2004-01 - 2006-12
● Developed and maintained relationships with customers and suppliers through account development.
● Accomplished multiple tasks within established timeframes.
● Cross-trained existing employees to maximize team agility and performance.
● Developed plans, guidelines, and policies for the implement and acquisition of hardware for the division.
● Responsible for all types of databases problem and take a quick decision for resolve the problems. Maintenance backup into tape device.
● Prepared training materials and documents of all RHD software for RHD officials and trained around 5500 government officials.
2001-08 - 2004-01
● Revised, modularized and updated old code bases to modern development standards, reducing operating costs, and improving functionality.
● Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development.
● Documented technical workflows and knowledge to educate newly hired employees.
● Designed intuitive graphical user interfaces to improve user experience.
● Designed reusable and reliable code for use within distributed cloud environments.
● Discussed issues with team members to provide resolution and apply best practices.
● Architected data engineering pipelines to support machine learning performance.
● Developed software for desktop and mobile operating systems.
● Built databases and table structures for web applications.
● Optimized dust, temperature and humidity controls for installed systems.
Academic Background
2001-01 - 2002-01
1999-01 - 2001-01
2023-11 - 1997-01
2023-11 - 1996-01