SUMMARY:

• Skilled IT professional with 8 years+ of extensive experience in IT environment with Database Administration, Analysis, Modeling and Development with BI Solutions (SSIS, SSAS & SSRS) which is enhanced by a Master’s degree and global certifications.
• Extensive experience in Database Administration with the skills such as Backup \ Restore, Recovery, Replication, Mirroring, Clustering, Always On, Performance Monitoring, Development using T - SQL in SQL Server 2016, 2012, 2008 R2, 2005 and 2003.
• Strong software development background with the knowledge of OOPS, SDLC and different programming languages including .NET, C#, PHP, JAVA etc.
• Experience working with AWS Cloud, Windows Server (Active Directory), DHCP, DNS, HTTP,TCP/IP, SSL and OSI Model Configurations in organization

COMPETENCIES:

• Database Administration, Development, Application Support and BI solutions
• Business Intelligence ( SSIS, SSAS and SSRS ), Data Warehouse/ Database design and Development
• SQL Server 2012, 2008 R2, 2005, 2003, MS Access Support and Administration
• Windows Server 2012, 2008 R2, 2003 Administration with Active Directory (User Creation, Policy Implementation, Edit and manage)
• Programming using HTML, XML/XSL, DTD, PHP, Visual Studio, VB.net, T-SQL, ASP.NET, MySQL, Ajax, Query, MVC (CI), SharePoint, WordPress, Joomla)

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator

Responsibilities:

• Daily database administration over 3500 databases in AWS Cloud
• Providing daily rotational 24X7 Production on-call support
• Working for extensive data backup, restoring, user creation, user role assignment
• Extensively working on migration of Databases from SQL 2005 and SQL 2012 to SQL 2016.
• Building several SQL Server DB clusters for High Availability and Database Mirroring for Disaster Recovery.
• Involving in Capacity Planning and provisioning of Hardware resources for SQL Database servers.
• Monitoring SQL Server instances to ensure database integrity and highest customer satisfaction.
• Developing backup & recovery strategy during disasters.
• Managing and maintaining high availability using clustering, replication and other means
• Writing / Editing / Updating Stored Proc, views and script as per the business need
• Developing and updating SSIS packages as required
• Administering security, user account management and access privileges.
• Implementing SQL Server maintenance plans for DBs’ backups, optimization and integrity checks.

Environment: SQL Server 2005/2012/2016 , AWS Cloud, Windows server 2003/2008/2012 , Red Gate Package (SQL Backup 6/7, Multiscript etc.), IDERA, JIRA, New Relic, Net Suite, Vmware, Windows Server 2012 / 2008 R2/2005

Confidential

Database Analyst

Responsibilities:

• Worked daily with production database to import, Export and Analysis of data using T- SQL
• Designed, Edited and support the SSIS packages for data extraction
• Edited / Updated Stored Proc, views and script as per the business need
• Developed and updated SSIS packages as business need
• Worked for extensive data backup, restoring, user creation and user role assignment
• Imported, exporting, analysis, mining and manipulation of database with SQL Scripting
• Worked for Day to day troubleshooting on production DB issues
• Operated and troubleshooting of JIRA, Fisheye and Confluence programs for daily operation
• Worked for daily compilation and integration of packages written in JAVA
• Worked on Jenkins and Tomcat servers for daily build and integration
• Validated, troubleshooting and implementing programs written in different programming languages
• Worked on AJILE environment

Environment: SQL Server 2005/2008/2012 , SSIS, SSRS, Red Gate Package (SQL Backup 6/7, Multiscript etc.), JIRA, Net Suite, Vmware, Windows Server 2012 / 2008 R2/2005

Confidential

Database / Build & Integration Analyst

Responsibilities:

• Worked for extensive data backup, restoring, user creation and user role assignment
• Worked for Importing, exporting, analysis, mining and manipulation of database with SQL Scripting
• Managed databases, servers, instances and resources for developers and QA’s
• Worked for Day to day build & integration and troubleshooting applications
• Worked on operating and troubleshooting of JIRA, Fisheye and Confluence programs for daily operation
• Worked for daily compilation and integration of packages written in JAVA
• Worked on Jenkins and Tomcat servers for daily build and integration
• Worked to Validate, troubleshoot and implement programs written in different programming languages
• Worked on regular SLA update and AJILE environment

Environment: Windows Server 2008 R2/2005, SQL Server 2005/2008/2012 , Red Gate Package (SQL Backup 6/7, Multiscript etc.), JIRA, Net Suite, JENKINS, Svn, Active Directory, SharePoint, Vmware.

Confidential

IT / Database Specialist

Responsibilities:

• Worked for Importing, exporting, analysis, mining, manipulation of data using SQL Scripting
• Supported clients working for inbound and outbound call Center
• Installed and modified software as per the business need
• Executed Stored Procedures to perform the task
• Ensured the timely completion of all daily/weekly/monthly reporting requirements
• Developed SSIS Packages and performed ETL process
• Developed Cubes, used Pivot tables, MS Excel and CSV files to upload data in SQL database
• Prepared different types of report using Crystal Report
• Supported a wide variety of applications including database platforms and reporting suites (ie. SQL, Advantage, Foxpro, Excel, Crystal reports etc.

Environment: Windows Server 2008 R2, SQL Server 2008 R2/2005, SSIS, SSAS,SSRS, MS Access, Crystal Report, Active Directory, SharePoint, SVN, Vmware.

Confidential

Sr. Database Administrator \Application Support Analyst

Responsibilities:

• Provided rotational 24X7 Production on-call support.
• Extensively worked on migration of Databases from SQL 2000 and SQL 2005 to SQL 2008.
• Built several SQL Server DB clusters for High Availability and Database Mirroring for Disaster Recovery.
• Involved in Capacity Planning and provisioning of Hardware resources for SQL Database servers.
• Monitored SQL Server instances to ensuring database integrity and highest customer satisfaction.
• Developed backup strategy and recovery during disasters.
• Administered security, user account management and access privileges.
• Implemented SQL Server maintenance plans for DBs’ backups, optimization and integrity checks.
• Configured Transactional replication between production & standby server for disaster recovery.
• Modified DTS, SSIS ETL package to load data from different source files to SQL Server tables.
• Used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of performance tuning.
• Developed, reviewed, and optimized queries for data retrieval and update for SQL developers.
• Developed and created data dictionary, tables, views, indexes, and functions advanced queries for databases using Query Analyzer and Enterprise Manager.

Environment: SQL Server 2008 R2, MS Access, Windows Server 2008 R2, Active Directory, SVN, IBM Servers, CISCO, Microsoft Forefront, Delphi, Oracle, C#, .net.

Confidential

Sr. IT / Database/ Application Support Analyst

Responsibilities:

• Installed and configured SQL Server 2000, 200 5 instances on virtual plus physical servers.
• Extensively worked on migrating database servers from SQL 2000 and SQL 200 5 .
• Performed capacity planning, monitoring Disk I/O, CPU and memory.
• Supported application implementation, operation, database monitoring and management
• Created & assigned privileges to Logins, transferred orphans logins between platforms after migration.
• Created and monitored SQL tasks like DTS packages, T-SQL commands and scheduling SQL jobs.
• Created alerts for system errors, insufficient resources, fatal database errors and security breach.
• Monitored overall units and supported end users for effective operation
• Supervised, Planned, Managed and ensured effective technology deployment
• Ensured daily operation of workstations, Servers, Routers and overall IT infrastructure
• Managed first of its kind telemedicine Centre in Nepal
• Monitored overall units of IT department such as hardware, software, datacenter and network etc
• Performed DBA duties including: database backup, restore, performance tuning, capacity analysis etc.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Designed, implemented and enforced SQL Server security policies according to client's Baseline.
• Documented scripts and project management plan according to client’s standards.

Environment: SQL Server 2000, 2005, Windows Server 2003, 2005, MS Access, VB, CISCO Routers, IBM Servers, PIX, Desktop Workstations, Adobe Packages, C#, .net

Confidential

Software Developer

Responsibilities:

• Identified and communicated technical problems and solutions with staffs and the management.
• Prepared proper documentation, reports and manuals for the systems
• Identified, evaluated and recommended available software products for running business processes.
• Maintained existing programs by making modifications.
• Involved in the development of logical and physical specifications
• Analyzed the business requirements and wrote Test Cases and Test Strategy for functional testing.
• Analyzed the system specifications and helped team members to achieve test goals.
• Documented and prepared Test Plans manually using Microsoft office tools.
• Followed up with the Developers to keep track of Modification Requests.
• Conducted Back-end and Regression testing during the various phases of the application.

Environment: Delphi, Ms Access, Developer 2000, Oracle 8i, etc.